Separation of first and last name into 2 columns

M

Mark

I have a spreadsheet that holds a person's first and last
name in one single column. I'd like to separate that
column into two columns, one with the first name and one
with the last name. Is there a formula that does that?
(I'm assuming it would use the space between the first and
last name as a measuring stick). Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top