close
I have #'s in columns and need to add a prefix to each column, I have about
10k rows
Hi Kim,
=quot;the prefixquot; amp; a1 pull down..then copy gt; paste special gt; values to get
rid of the formulas.
=quot;the prefixquot; amp; quot; quot; amp; a1 if you want a space between the prefix and #'s.
HTH
Regards,
Howard
quot;kimquot; gt; wrote in message
news
gt;I have #'s in columns and need to add a prefix to each column, I have
gt;about
gt; 10k rows
全站熱搜
留言列表
