Excel---how do i automate adding a suffix to text?

G

Gary''s Student

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to Converts a number to english text and adds a suffix of "do. 1
Prefix and Suffix 2
sorting numbers and numbers that contain text in excel 2
I'd like to add a suffix... 4
Compare text in cell to custom text format?? 1
Number stored as text: Frustrated with Excel-Word Merge 2
Formatting text column 1
Using a macro in excel to hyperlink files 1

Top