Thread: Text to Columns
View Single Post
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default

After you've indicated to Excel where to split the string, click on the next
button. One after the other highlight each of the columns you've indicated
and click on the Text option

"Don" wrote:

I am doing a 'Text-to-columns' activity on particular columns of cells
containing numeric digits only .... The data is segmented as required - but I
keep 'losing' the leading zero (eg 01753443202) ends up with 1753 in one
column, and 443202 in the adjacent one ....... How do I retain the zero.

Thx,

Don-