Skip to Content
avatar image
Former Member

Ad comma to a column

HI I have a column that has name data like this

'Last_name First_name'

I would like to add a comma, after the Last_name. Can this be done in formula?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 25, 2017 at 06:30 AM

    Hi Paul,

    Create a formula with this code:

    Left({Name Field}, Instr({Name Field}, " ")-1) & ", " & Mid({Name Field}, Instr({Name Field}, " ")+1)

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 25, 2017 at 12:42 PM
    Replace({Name Field}, " ", ", ")

    This assumes you have only 2 elements in the name field.

    Add comment
    10|10000 characters needed characters exceeded