If that won’t do, you can write a formula that says ”give me all the text to the left or right of a particular character

If that won’t do, you can write a formula that says ”give me all the text to the left or right of a particular character number and that character number is the first instance of a found space character” I would have to look it up but it’s something like =Left(Cellname,instr(cellname,” ”),len(Cellname instr(cellname,” ”) According..