How to Split Names or Addresses from One Cell into Multiple Cells in Google Sheets

Works with names and addresses

Savvies, if you have been doing this manually before, you no longer have to do it. Let Google Sheets take care of it for you.

The function shown in the video is =SPLIT(A1, “,”)

If your text in the row is separated by a space (Ex. Hardware Savvy) then put a space in the quotation marks.

If the text is separated by a comma, like in the video (ex. Hardware,S…

Watch with a 7-day free trial

Subscribe to HardwareSavvy to watch this video and get 7 days of free access to the full post archives.