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

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…