Forum Discussion
Solved
Find a return in a text Filed
I'm trying to filter out out possible information. This is how information was entered into one text field. ------ Company name Address City StateZip ------- That is in all one field with retu...
=MID(B5,FIND(CHAR(10),B5,FIND(CHAR(10),B5)+1)+1,FIND(" ",B5,FIND(CHAR(10),B5,FIND(CHAR(10),B5)+1))-FIND(CHAR(10),B5,FIND(CHAR(10),B5)+1)-1)You can try the attached file with this formula in cell B12. The formulas in range B9:B13 are copied to the right.
=MID(B5,FIND(CHAR(10),B5,FIND(CHAR(10),B5)+1)+1,FIND(" ",B5,FIND(CHAR(10),B5,FIND(CHAR(10),B5)+1))-FIND(CHAR(10),B5,FIND(CHAR(10),B5)+1)-1)You can try the attached file with this formula in cell B12. The formulas in range B9:B13 are copied to the right.
