We help IT Professionals succeed at work.

separate Excel column


I have an Excel spreadsheet which contains something similar to the below:

Smith, Jane
Ortiz, Jon
Roberts, Donald

I want to separate the column into last name and first name:

Smith          Jane
Ortiz           Jon
Roberts      Donald

Please assist and advise a formula to do that.

Thanks in advance!
Watch Question

Use text to columns under the data tab.  Pick delimited and use the comma as a delimiter.  If the data is not exactly as you showed (all with the commas) then there are other alternatives.

Hi Nav2567

Use these formula:

in B2

=LEFT(A2, SEARCH(",", A2,1)-1)

in C2


Thank you.