| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding spaces to a text field
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding spaces to a text field
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace spaces at the end of a field | Excel Discussion (Misc queries) | |||
| How do I put spaces in a field | Excel Discussion (Misc queries) | |||
| Adding Text to Calculated Field | Excel Worksheet Functions | |||
| Adding a hylerlink to a text field | Excel Discussion (Misc queries) | |||
| How do you remove excess spaces from an Excel field? | Excel Discussion (Misc queries) | |||
Linear Mode
