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

Works with names and addresses

Apr 30, 2022
∙ Paid

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…

The full video is for paid subscribers