Adding spaces to a text field
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
"Jason Trolian"
wrote in message
...
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
.
|