Converting text to columns


show more Converting text to columns provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training show less
please wait ...

Converting text to columns

There will be some times that you'd like to be able to grab some information that's included in one column in your worksheets, and break it out into two. I've opened up a employee area in my EatCake Human Resources worksheet, that requires my employees to login with a user ID. And I'd like that user ID to be their first initial of their first name and their last name. And this is exactly how I've created their email addresses. So I'm going to use this as my starting point. I want to break out their email addresses into two pieces, the information before the @, and then the information after the @.

Now, to do that, I'm going to use the Text to Column command in my Data Tools group under my Data tab. Before I do that though, I want to make sure I've got enough area where that information is going to go. Because if I started to break it out now, it's going to overwrite my start date, and that's not something I want to happen. I want to retain that inf...

Converting text to columns
Video duration: 4m 35s 5h 13m Beginner

Viewers:

Converting text to columns provides you with in-depth training on Business. Taught by Lorna Daly as part of the Excel 2007 Essential Training

Subject:
Business
Software:
Excel
Author:
please wait ...