Results 1 to 3 of 3

Thread: How to add commas after each text in each cell using Excel Macro

  1. #1
    Join Date
    Dec 2011
    Posts
    61

    How to add commas after each text in each cell using Excel Macro

    I have a list of about 23,000 emails. I need to make an E-mail blast. The only way I know how to do that is by adding a comma at the end of each one. How can I save the hassle of inserting a comma manually into each cell? If you have any information then please do the reply.

  2. #2
    Join Date
    May 2009
    Posts
    210

    re: How to add commas after each text in each cell using Excel Macro

    According to my information, you just try this out

    • In an adjacent helper column (column B), put this in B1 and copy down. =A1&","
    • Then do Copy > PasteSpecial > Values on that column to get rid of the formulas.

    May this will help you out to do this query in excel.

  3. #3
    Join Date
    Nov 2009
    Posts
    140

    re: How to add commas after each text in each cell using Excel Macro

    You should try this short macro, so for that you just have to create a sub procedure.

    Sub AddComma()

    Dim cell As Range
    For Each cell In Selection
    If cell.Value <> "" Then
    cell.Value = cell.Value & ","
    Else: cell.Value = cell.Value
    End If
    Next cell
    End Sub
    • Place the code in a general module.
    • And after that select the range of cells in question then run the macro.

Similar Threads

  1. Need help to convert a Text file to Excel via VBA Macro
    By DEvOTeEL in forum MS Office Support
    Replies: 1
    Last Post: 24-02-2012, 01:47 PM
  2. Replies: 2
    Last Post: 23-02-2012, 02:54 PM
  3. Replies: 6
    Last Post: 23-07-2011, 01:05 AM
  4. Macro- Excel to copy cell content highlighted
    By Anwar in forum Windows Software
    Replies: 3
    Last Post: 06-03-2009, 02:04 PM
  5. Excel Added macro for cell color
    By Xylon in forum Software Development
    Replies: 3
    Last Post: 19-02-2009, 12:15 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,622,519.93465 seconds with 17 queries