Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Insert a comma at the end of text in each cell in a range of

  1. #1
    Join Date
    11th April 2003
    Posts
    1


    Okay I'm through trying to figure it out on my own!!

    How do I insert a comma (,) at the end of the text in each cell in a range of cells (in Excel). Do I have to create a macro to do that and if so How do I do that? or is there a function that will do it for me? or do I have to use the concatenate function to do that???

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    29th March 2003
    Posts
    39
    Originally posted by missbaby


    Okay I'm through trying to figure it out on my own!!

    How do I insert a comma (,) at the end of the text in each cell in a range of cells (in Excel). Do I have to create a macro to do that and if so How do I do that? or is there a function that will do it for me? or do I have to use the concatenate function to do that???
    Maybe this?

    =A1&","

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    28th January 2003
    Posts
    3
    for each cell in Selection
    cell.value = cell.value & ","
    next cell

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Find Cell With Text & Insert Formula Below
    By crugg1 in forum EXCEL HELP
    Replies: 4
    Last Post: June 11th, 2008, 10:16
  2. Insert Text Into Autoshape Based On Cell Value
    By Upside in forum EXCEL HELP
    Replies: 1
    Last Post: November 24th, 2007, 07:52
  3. Insert text from cell into inputbox message
    By ShawnIRQL in forum EXCEL HELP
    Replies: 3
    Last Post: April 21st, 2006, 00:55
  4. insert text from cell into userform
    By AlanU in forum EXCEL HELP
    Replies: 8
    Last Post: March 25th, 2005, 01:17
  5. insert contents of cell into text
    By joop in forum EXCEL HELP
    Replies: 4
    Last Post: January 13th, 2005, 18:08

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
  •  
porno