Joseph Horling
Member
Hi Chandoo,
I would like to use this formula: to find the other spaces in my text. There is about 8 spaces in my text and I would like to extract the text from each space. Not sure how to find the other spaces. I want to get the last name, street no, street name, city, state, and zip separate. Do I use more finds? Hope I explained this correctly. Attached is my file. Thank you for your help, Joe from Michigan.
I would like to use this formula: to find the other spaces in my text. There is about 8 spaces in my text and I would like to extract the text from each space. Not sure how to find the other spaces. I want to get the last name, street no, street name, city, state, and zip separate. Do I use more finds? Hope I explained this correctly. Attached is my file. Thank you for your help, Joe from Michigan.