Text To Column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have part numbers like this one "ACC0123". We are trying to seperate the
ACC and the 0123. However, when we do the text to column and fixed width, the
"0" gets dropped. Have changed the field to be text, general, number and
nothing seems to keep the "0".
Any ideas?

Thanx
 
On Step 3 of the "Text to Columns" Wizard, make sure you set BOTH columns to
format as text. By default, only the first column is select, thus any
changes made here are only to that column.

HTH,
Elkar
 
Thanx but that didn't work either.

Elkar said:
On Step 3 of the "Text to Columns" Wizard, make sure you set BOTH columns to
format as text. By default, only the first column is select, thus any
changes made here are only to that column.

HTH,
Elkar
Click to expand...
 
It works fine for me. Just to clarify, in the Data Preview window on Step 3
of the Wizard, you're clicking to highlight your 2nd colmun there, before
selecting "Text" as your Column Data Format?

That should work. If not, what version of Excel are you using? I'm using
Excel 2003. Perhaps there is some difference in older versions that I'm not
aware of.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif Problem (or suggestion for alternative) 6
SUM only Cells where there is text in Another cell 1
Text to Columns from the Left 2
text to column 1
Birthdate 01/01/2000 Remove Slashes 2
How to count the maximum number flanked by zeros 9
text match formula not working 2
Convert Number to Text for Index/Match 1

Back
Top