Split excel text into two cells

broken image

I want to put in a new column that has everybody's usernames in there. It has a first name, last name, department, email address, and telephone extension.

broken image
broken image

But this time, I'm going to show you an example that has to do with text, not numbers.

broken image

Sometimes you may find that you think you're going to need to write a formula to do something, but as it turns out, Excel already has the capabilities to do that built in, kind of like AutoSum.

broken image