Retrieving parts of a text fields

Eyglo

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.

Peggy Parchert

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.

Peggy

Peggy Parchert

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.

Peggy

Eyglo

This worked. Thank you so much Peggy.

Peggy Parchert

@Eyglo

Great! Happy to help. Have a great rest of your week.

Peggy