Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to eliminate E-mail "To" & "CC" boxes at top of Excel Sheet BillFitz Excel Discussion (Misc queries) 10 March 24th 08 11:42 AM
Signature missing when "send to" "mail recipient" Jim Tortorelli Excel Discussion (Misc queries) 2 September 21st 07 05:19 PM
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F daves Excel Discussion (Misc queries) 3 April 24th 07 04:52 AM
Change the "Insert Function" display for mail merge Beach Lover Excel Worksheet Functions 3 November 1st 06 06:41 PM
Insert "-" in text "1234567890" to have a output like this"123-456-7890" Alwyn Excel Discussion (Misc queries) 3 October 25th 05 11:36 PM


All times are GMT +1. The time now is 12:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"