Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing Comma delimited file
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. -- Patsy Rogge 012-420 7240 012-420 7230 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing Comma delimited file
Hi Patsy,
Try importing as a text field and then use a helper cell to =trim(A1) Adjust cell reference as required HTH "Patsy Rogge" wrote: 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. -- Patsy Rogge 012-420 7240 012-420 7230 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing Comma delimited file
Thanks Ray, it works
-- Patsy Rogge "Ray A" wrote in message ... Hi Patsy, Try importing as a text field and then use a helper cell to =trim(A1) Adjust cell reference as required HTH "Patsy Rogge" wrote: 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. -- Patsy Rogge 012-420 7240 012-420 7230 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CANNOT Import comma delimted, quote qualifed text file into Excel. | Excel Discussion (Misc queries) | |||
Importing MM:SS From Tab Delimited File and Charting | Charts and Charting in Excel | |||
Links picking up values from an older version of linked file | Links and Linking in Excel | |||
importing data from txt file | Excel Discussion (Misc queries) | |||
save an Excel worksheet as a comma delimited file? | Excel Discussion (Misc queries) |