Splitting Text String Across Rows

[CHarding]

Hi guys,

Got a relatively simple one... I was wondering how I'd go about splitting out a string of text I've got in one cell so that it shows up in a "list" rather than a string.

Example:

• I've currently got 123,321,123,321 in cell D1
• I'd like to move this data to show up over cells A1, A2, A3 & A4 (even if they're actually all in A1, they display in this way)

 

[VoG]

Try Data > Text to Columns, delimited with , as the delimiter. This will split the string into D1:G1.

 

[CHarding]

Cool, is it possible to perform this action so the destination cells are vertical rather than horizontal?

 

[VoG]

If you now copy D1:G1 then click in A1 and Edit > Paste Special, tick Transpose and click OK, that will create a vertical list.