Hi Kim,

="the prefix" & a1 pull down..then copy paste special values to get
rid of the formulas.

="the prefix" & " " & a1 if you want a space between the prefix and #'s.

HTH
Regards,
Howard

"kim" wrote in message
...
I have #'s in columns and need to add a prefix to each column, I have
about
10k rows