ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to insert comma (",") in the end of each mail ID? (https://www.excelbanter.com/excel-discussion-misc-queries/200855-how-insert-comma-end-each-mail-id.html)

nvrmba

How to insert comma (",") in the end of each mail ID?
 
Hi,
Iam new to this group. I have 1025 mail id's. I want to add one
comma(",") end of each mail ID..Plz. let me know how to do it?

Thanks in advance..

Regards,
nvr.

David Biddulph[_2_]

How to insert comma (",") in the end of each mail ID?
 
If your IDs are in column A, use =A1&"," in B1, and copy down. If you want
to replace the original version by the new version, copy, then edit/ paste
special/ values.
--
David Biddulph

"nvrmba" wrote in message
...
Hi,
Iam new to this group. I have 1025 mail id's. I want to add one
comma(",") end of each mail ID..Plz. let me know how to do it?

Thanks in advance..

Regards,
nvr.





All times are GMT +1. The time now is 07:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com