Use a helper column:

Say your data is in column A. In B1 enter:

="_" & A1
and copy down. Then copy column B and paste/special/values back onto column
A.
--
Gary''s Student - gsnu200781


"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.