Worked Perfect!!! Thank You!!!!!

"Dave F" wrote:

Create a helper column with the following formula (assumes your numbers are
in column A):

=CONCATENATE("xxx",A1) and fill down to the end of your range. Then copy
the helper column, paste special, values, on column A, and delete the helper
column.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Sharon R" wrote:

I have a column of #'s, I need to add 3 letters in each cell before the #'s.
Is there a formula for this, so I wouldn't have to retype all the #'s?