logo elektroda
logo elektroda
X
logo elektroda

Excel: Add Comma or Custom Character to End of Each Cell (Automatic Formula for Hundreds of Values)

Rogi1989 20583 1
ADVERTISEMENT
Treść została przetłumaczona polish » english Zobacz oryginalną wersję tematu
  • #1 12301998
    Rogi1989
    Level 9  
    Hello.
    How do I add any character (e.g. a comma) to the end of each cell? I mean the automatic formula for several hundred values.
    Thank you in advance.
  • ADVERTISEMENT
  • Helpful post
    #2 12302028
    dt1
    Admin of Computers group
    I would approach the topic in two ways:

    - display formatting - set a custom format for the cell, and enter as the type: @ "," - of course, there can be anything else in quotation marks instead of a comma
    - a function that connects text - assuming column A are your values - in cell B1 you create a function: CONCATENATE (A1, ",") - then you extend the function from cell B1 to the rest of column B. You hide column A and get the result you expect (with the difficulty that any editing of values must still be done in column A).
ADVERTISEMENT