If your data is in column A add a column B and enter this formula in cell B1
="**"&A1 . Then fill this formula down the column. Copy column B paste
special values into column A then delete column B.

Carlos


"Tammy Singer" <Tammy wrote in message
...
Is there a way to insert a standard character before each cell of a
predetermined column?

For example, the info in the field says C01. I need for it to say **C01.
It would take me hours to manually put a ** in one thousand records in the
column.

Any help would be great!
Thans.