![]() |
Excel---how do i automate adding a suffix to text?
i want add a suffix to a column of text values. How do i do this?
|
Excel---how do i automate adding a suffix to text?
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. -- Gary''s Student - gsnu200766 "Peter-NYC" wrote: i want add a suffix to a column of text values. How do i do this? |
All times are GMT +1. The time now is 11:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com