September 23, 2010

Microsoft Excel 2007 – Splitting Text from One Cell to Several Cells

Have you ever gotten a spreadsheet, and you need to break up the first and last name or break the address down to street address, city, state & zip. There is a very easy way to do this without retyping the information.

1.  Insert the correct number of columns you will need once the data is
     split. For example, if you have Miller, John, you would insert 1
     column to the right of Miller, John so that the text has a place to
     be inserted.

2.  Highlight the column that contains the data that needs to be split.

3.  Click on Data in your ribbon.

4.  Click on Text to Columns and a dialogue box will appear.

5.  For our example, you would pick Delimited, press the Next
     button.

6.  Pick what your delimiters would be (tab, semicolon, comma,
     space, other). For our example, it would be comma.

7.  Excel will then draw a line in the dialogue box to show you
     where it will split your text. If you are satisfied that it done
     correctly, click Finish and watch what happens.

It’s a neat trick, and a time saver. Try it!

No comments:

Post a Comment