leading zero problem

  • Thread starter Thread starter Support
  • Start date Start date
S

Support

Hi, I have been given some call data from my telecomms provider in csv
format.
I have tried importing that into excel so I can then import into an access
table but the format got messed up so I have converted the raw data file to
txt.
Problem with both when I import into excel is that in my CalledNo cell, I
have a leading space in front of the phone number which is of the format
01234567890.
I have tried using the data > text to columns tool but this deletes the 0
even tho I keep the cell format as text.
I have also tried TRIM function however not all numbers are the same length.
Thanks
 
managed to sort this:
2 step procedure:
do data text to columns and let leading 0 be deleted.
put in a column of 0 and then in a new colum, do a CONCATENATE of the 2
cells, then paste special...
 
Hi support

one step procedure
do data text to columns BUT after choose the first NEXT and the second NEXT,
click on the column with the 0 in front of the numbers and then chose Text
before clicking FINISH

Cheers
JulieD
 
Back
Top