Strip out from Contact

Phil Smith
edited 12/09/19 in Formulas and Functions


I have a sheet with a column for 'created by' (for form entries) and need to be able to strip out the text so that I'm just left with the individuals name in a separate column.

Ideally, I would also like to add a space between firstname.lastname at the same time.

example: to firstname surname

Thanks in advance.





  • oj6_projmgr

    You could use the RIGHT function to remove the part

    Then use the REPLACE function to turn that . into a space

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    In my opinion, REPLACE() is too clunky for this usage. Better is SUBSTITUTE()

    The answer also is a bit vague as RIGHT() returns the part that is being discarded and LEFT() won't get the result without knowing how to find the @ symbol. 

    Part 1: Get the name from the left of the @ symbol

    =LEFT([Created By]@row, FIND("@", [Created By]@row) - 1)

    Part 2: Replace the "." with a " " space

    =SUBSTITUTE(LEFT([Created By]@row, FIND("@", [Created By]@row) - 1), ".", " ")

    Hope this helps.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!