Retrieving parts of a text fields


Hi there,

I have a project identifier column that includes a project code (111-AAA) and project name (client name). Ex: 123-ABC Disney Corp

I would like to separate the Project Code and Project Name into 2 Columns, which will result in me having 3 columns Project Identifier, Project Code and Project Name.

For the 'Project Code' split I used this formula successfully:

=IFERROR(LEFT([Project Identifier]@row, FIND(" ", [Project Identifier]@row) - 1), " ")

However, I am having more issues with retrieving the Project Name. I have tried:

=IFERROR(RIGHT([Project Identifier]@row, FIND([Project Code]@row, [Project Identifier]@row)), " ")

The thought is that I would like pull everything right of the project code (123-ABC) but I only get the result "p".

Any tips and tricks I would appreciate. Thank you.

Best Answer

  • Peggy Parchert
    Peggy Parchert ✭✭✭✭✭✭
    Answer ✓

    Hello @Eyglo

    Hope you are doing well. Try this in your Project Name column:

    =IFERROR(RIGHT([Project Identifier]@row, LEN([Project Identifier]@row) - FIND(" ", [Project Identifier]@row)), [Project Identifier]@row)

    Hope it helps.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!