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

Apr 30, 2022

Savvies, learn how to do it in today’s post 👇

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

Watch now (16 sec) | 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…

3 years ago · Arsen Karapetyan

Comments

#nojs-banner { position: fixed; bottom: 0; left: 0; padding: 16px 16px 16px 32px; width: 100%; box-sizing: border-box; background: red; color: white; font-family: -apple-system, "Segoe UI", Roboto, Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 13px; line-height: 13px; } #nojs-banner a { color: inherit; text-decoration: underline; } This site requires JavaScript to run correctly. Please turn on JavaScript or unblock scripts