i want add a suffix to a column of text values. How do i do this?
G Gary''s Student Jan 29, 2008 #2 Say the data is in column A. In B1 enter: =A1 & "suffix" and copy down. Afterward, copy column B and Paste/Special/Values back onto column A.
Say the data is in column A. In B1 enter: =A1 & "suffix" and copy down. Afterward, copy column B and Paste/Special/Values back onto column A.
