In Excel, is there a way to split a row with one cell with multiple values into multiple rows with each of their correct values?

Answer 1

Depending on what your particular data is, you can likely use Text-to-Coulmns here. Try:

1) Select the cell in question

2) Data > Text to Columns (within Data Tools)

3) Choose either Fixed-Width or Delimited

Fixed-Width: use this if your data is equally spaced (e.g., 123456 to become 12, 31, 56)

Delimited: use this if you have separators in your data (e.g., UserName-456-Georgia to become Username, 456, Georgia)

4) If choosing Delimited, set your Delimiter (e..g, tab, comma, etc.)

This should output your one cell into many cells, horizontally. If these do not solve your problem you will likely have to use IF statements with string splicing function such as LEN, LEFT, RIGHT, etc.

Answer 2

you can do text to columns

otherwise you will have to write some code...

sound like you will have to parse the text over delimiters such as space or comma separated values