Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Inserting a Coma in a rows

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm trying to insert some coma's @ the end of each number on every row....I have 6000 numbers and do not want to go to each cell and put a coma behind the number. How would I fix the problem to enter it in on everyone.
    Example: Trying to get it to look like the first two.

    12,
    14,
    16
    18

    Any help would be greatly appreciated




  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =A1&","

    If you don't want the last number in the list to have a comma use...

    =A1&IF(LEN(A2)>0,",","")

    [ This Message was edited by: Mark W. on 2002-04-26 13:06 ]

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Where would I enter that formula?

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If your 1st number is in cell A1 enter either of these formulas in B1.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •