Solved

Excel 2007 Text to Columns Without Changing Numbers

Posted on 2013-12-06
2
327 Views
Last Modified: 2013-12-06
Hello,

I am trying to separate numbers and text in a column but when I run the Text to Column function its removing the zeros in front of the numbers and I want them to remain intact.  For example, a cell that shows:  000111 Joe Smith will end up having 111 in one column and Joe Smith in the other once the data is split.

Any recommendations on how to prevent this from happening?  Open to macros if that's the best solution.

Thanks!
0
Comment
Question by:Escanaba
2 Comments
 
LVL 23

Accepted Solution

by:
NBVC earned 500 total points
ID: 39701296
In the 3rd window of the Text to Columns wizard, select that column in the preview pane.  Then select Text in the column Data Format section.  This should keep that column as Text string.
0
 
LVL 1

Author Closing Comment

by:Escanaba
ID: 39701524
Thanks!
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question