Splitting a Name in Excel


This is not the deepest or most important post – it kind of ranks with the one about turning headers purple- but I know I want to remember how to do this and it might be helpful for some others. When Microsoft Forms captures data from Henry Ford College automatically it puts the respondent’s first and last name in the same field. If you are working with a lot of data you do not want that. You probably want to alphabetize for instance. The video below shows how to split the names.

Splitting A Column in Excel

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s