Importing Comma delimited file

P

Patsy Rogge

Hi

I am importing a comma delimited text file into excel. I have an account no
which is a alpha numeric field and when I import it a general format the 0's
in front of the account no disappears. If I import it as text field it add
blanks spaces at the end and I need to do a match on this field.
 
R

Ray A

Hi Patsy,
Try importing as a text field and then use a helper cell to =trim(A1)
Adjust cell reference as required
HTH
 
P

Patsy Rogge

Thanks Ray, it works

--
Patsy Rogge

Ray A said:
Hi Patsy,
Try importing as a text field and then use a helper cell to =trim(A1)
Adjust cell reference as required
HTH
Click to expand...
 

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

Format change in merge data - Bold formatting after a comma 0
Excel does not accept text format! 0
Select Text to End of Footnote 9
Excel2007 importing issue/bug 0
Saving as tab delimited or comma delimited 0
Import a comma delimited file & match records 3
Text Files 2
Comma Delimited-need comma at beginnng & end 2

Top