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

I have a column of part no. and descriptions that are separated by a space. I
know how to separate them with the help of DATA/TEXT To COLUMN However when
I use the fixed option and move my vertical arrow to separate the part no.
and description I end up either not grabbing the whole part no. or the
description. Is there way I can add spaces /indent so that I can use that
option?