Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Lære Splitting Text to Columns | Advanced Formatting of Cells
Google Spreadsheets Tutorial

bookSplitting Text to Columns

Suppose you have the string John Doe, 123 Main St, New York in cell A1. Using the Split Text to Columns tool, you can easily split this string into several columns: first name, address, and city.

question mark

Which delimiter would correctly split the following text into three separate columns:

Select the correct answer

Var alt klart?

Hvordan kan vi forbedre det?

Tak for dine kommentarer!

Sektion 3. Kapitel 1

Spørg AI

expand

Spørg AI

ChatGPT

Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat

Suggested prompts:

Can you explain how to use a custom delimiter in more detail?

What happens if my data contains different delimiters in the same cell?

Are there any limitations or things to watch out for when splitting text to columns?

bookSplitting Text to Columns

Stryg for at vise menuen

Suppose you have the string John Doe, 123 Main St, New York in cell A1. Using the Split Text to Columns tool, you can easily split this string into several columns: first name, address, and city.

question mark

Which delimiter would correctly split the following text into three separate columns:

Select the correct answer

Var alt klart?

Hvordan kan vi forbedre det?

Tak for dine kommentarer!

Sektion 3. Kapitel 1
some-alt