That's better for taking care of the blank columns but you must've missed my
reply to the last suggestion as they were both posted within minutes of
eachother.

"Kevin B" wrote:

Create a helper column to the right of your data column, and use the
following formula to add the underscore "_" as a prefix character (Modifying
the A1 cell address to match your worksheet layout):

=IF(ISBLANK(A1),"","_"&A1)

Copy down to the last data row then copy the entire formula column, click on
the first cell of the original data column (Cell A1 in the formula example),
then click EDIT in the menu, select PASTE SPECIAL and click the VALUES option
button. Click OK to complete the process and exit the dialog box. Delete
the helper column when done.
--
Kevin Backmann


"Jon in Canby Or." wrote:

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.