Thread: Text To Column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nancy
 
Posts: n/a
Default Text To Column

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