How to Split Full Name and LinkedIn URL into Two Columns in Excel

Hey everyone! Can I use a formula with a full name and linkedin URL to split it into 2 different columns. eg: [john smith, https://linkedin.com/john-smith] Splits to cell 1 = [john smith] & Cell 2 = [https://linkedin.com/john-smith] Name and Linkedin URL are separated by a "," I've tried but it keeps outputting it back to one column.