View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jon in Canby Or. Jon in Canby Or. is offline
external usenet poster
 
Posts: 5
Default Hopefully a simple macro to precatenate data in a column

Sorry if this is really easy or not possible. I'm a dba with very little
Excel experience. I've been given an Excel spreadsheet to import into a
relational database there are some data consistency issues...

Anyway, what I'd like to do is insert an underscore at the front of the data
in each cell in a column - preferably in only those cells that have data. So
if the cell has ABCDEF in it it'd become _ABCDEF .

Any clues on how to accomplish this? Thanks.