I have #'s in columns and need to add a prefix to each column, I have about 10k rows
K kim Jan 24, 2006 #1 I have #'s in columns and need to add a prefix to each column, I have about 10k rows
L L. Howard Kittle Jan 24, 2006 #2 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
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
