Help with Txt extract formula

Jon Barto

Hello All

I am looking for some help with a txt formula.

Currently I am using this formula to extract txt from Construction Phase column..

=LEFT([Current Construction Phase]@row, FIND(" ", [Current Construction Phase]@row + " ")

What I really need is to extract all the 5- Finish Phase to Hard Floor.. Not the date numbers.

Another note is the first part maybe differant wording such as 2- Framing, ect…. but the date is always the same xx/xx/xx - xx/xx/xx if that helps Plus it is always (char 10) or returned to a seperate line.

Carson Penticuff

Give this a try:

=LEFT([Current Construction Phase]@row, LEN([Current Construction Phase]@row) - 20)