Question

I tried to split the text in Course Release date to two column if there is more than two dates.

For Course release date original column, I used

=LEFT([Course Release Date]@row, FIND(" ", [Course Release Date]@row))

For Course release date if refreshed column, I used

=RIGHT([Course Release Date]@row, LEN([Course Release Date]@row) - FIND(" ", [Course Release Date]@row))

I am not sure why it is not working and left column showing blank and right column pulled the whole text?

Paul Newcome · Accepted Answer

It looks to me like you are using line breaks instead of spaces. Try replacing the space with CHAR(10)

FIND(CHAR(10), [Course Release Date]@row)

Louisa Li · Accepted Answer

YEAH! That worked, thank you so much!

However, I want to original column to repeat the Course release date column when there is only one date, when there is more than one date I want the second date to be in the "If refreshed" column. I achieved that by using the formula below

FYI: I rename the Course release date column to Course Release Date - Helper

=LEFT([Course Release Date - Helper]@row, LEN([Course Release Date - Helper]@row) - FIND(CHAR(10), [Course Release Date - Helper]@row))

=IF([Course Release Date - Helper]@row <> [Course Release Date Original]@row, RIGHT([Course Release Date - Helper]@row, LEN([Course Release Date - Helper]@row) - FIND(CHAR(10), [Course Release Date - Helper]@row)), "")