ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel---how do i automate adding a suffix to text? (https://www.excelbanter.com/excel-discussion-misc-queries/174825-excel-how-do-i-automate-adding-suffix-text.html)

Peter-NYC

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?

Gary''s Student

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