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.
