Announcement

Collapse
No announcement yet.

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

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

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





    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???

  • #2
    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&","

    Comment


    • #3


      for each cell in Selection
      cell.value = cell.value & ","
      next cell

      Comment

      Working...
      X