Split to url in google sheets the long way.

Split URL to Columns in 11 easy steps.

Let’s use Google Sheets Split Url to Columns function now! https://dev3lop.com/split-url-to-columns/

1. Left-click the column header with URLs

1. Left click Data, Ctrl+Alt+D or Ctrl+Option+D,
2. Left click Split text to columns… or E

1. On the bottom of your browser — you’ll see a subtle menu. If you have a big screen, you could miss this at first! Google Sheets natively uses comma separator.

1. Left click Custom to open the wild card Split text to column finder.
2. Type @ to separate by a character or many.
3. Copy — Latitude — and paste it in column D header.

1. Left click column D to select the entire column of Latitude, Longitude, etc….

1. Left click Data, Left click Split Text to columns… (Refer to Step 4 screenshot above)
2. Use Custom for the separator, and leave it set to default comma.
3. Copy — Longitude — paste that to Column E.

Split url to columns - Dev3lop

Tableau Consulting - Ad-hoc Help or Long Term Projects. We Love Data.

Austin SEO Experts - Find the best Austin SEO Consultants