Split Text to multiple Column Formula not working?

Louisa Li

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

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

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)), "")

Paul Newcome

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

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)), "")