• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Leading Zeroes Disappear When Moving Text to Columns

smd1227

New Member
Hello. I routinely have to move text to columns leaving the alpha characters in the first column and moving the number to the second column: MAT001. When I do this the leading zeros disappear. I have already made all the cells text, but that doesn't work. Any ideas, please? TX!
 
when you use text to columns, you ca configure the data type of each column in one of the screens. There you can select the second column and set the type as text. This should correct the behavior.
 
Back
Top