Adding spaces to a text field

  • Thread starter Thread starter Jason Trolian
  • Start date Start date
J

Jason Trolian

I am trying to modify a .csv file prior to importing to a
table in access. the first colum of this spreadsheet
represents a record id # that is used in my existing
databaase. In my database that perticular field is 6
characters long. The id 1234 would appear " 1234". In
the spreadsheet that I am importing, It appears "1234 ".
How can I make the change so I wont physicaly have to add
the spaces before the record ID after importing? Thanks
in advance for any help you can offer.

Jason Trolian
 
in an adjacent column you could put in a formula like

=" " & trim(A1)

then drag fill down.
Select this column and do edit =>copy, then select column A and do
Edit=>Paste Special and select Values.

Then delete the adjacent column with the formula.
 
Thank you very much.
-----Original Message-----
in an adjacent column you could put in a formula like

=" " & trim(A1)

then drag fill down.
Select this column and do edit =>copy, then select column A and do
Edit=>Paste Special and select Values.

Then delete the adjacent column with the formula.

--
Regards,
Tom Ogilvy




.
Click to expand...
 
Back
Top