I am not that experienced with Google Sheets, just wanted to preface that. I am looking to have this sheet cleaned up so that each Address record also contains the Owner, Company, and all contact information associated with the property in a single record (row, etc.).

Address, City, ST, Zip, APN, Owner, Companies, People + All contact info for each person (phones + emails).

The current output is the only way the existing platform exports the info to maintain accurate data associated with each record.

I have included the link, you can see the people, phone, and email are all in single columns.

Any insight would be highly appreciated.


  • 1
    Hi, welcome to WebApps. Your spreadsheet requires permission to gain access. This will limit the number of people who may be able to help you. Please provide a copy of your spreadsheet that is accessible to anyone with the url. On a tangent, please don't expect users to read your spreadsheet in order to understand your question. You must supply all this information in the body of your question.
    – Tedinoz
    May 4, 2022 at 1:04
  • Please also include what research you have already done to solve this problem, what formulas or scripts you have tried and what the results were, and (somewhere in the sheet) what the exact expected results are alongside the results your own formulas or scripts produced incorrectly.
    – Erik Tyler
    May 4, 2022 at 14:45

1 Answer 1


You can use a split function

=Split("cellnumber","Split by "space", or ",")


Let me know if you need help with this You can search for split function in google sheet.

thank you

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.