I have one cell with multiple items.
How can I split one cell into multiple rows? I don't have a unique Delimited. I tried Textsplit, but getting errors. Any help is greatly appreciated
Can you show me how to use Textsplit or the formula
Since you have three columns of data, please mock up how you would like the result to look like. I want to be sure we supply the right answer before going forward. Also, which version of Excel are you using?
Hi Alan
Microsoft® Excel® 2019 MSO (Version 2509 Build 16.0.19231.20138) 64-bit
Row 1 is the download file, from the application.
I would like to see TextSplit output like in row 4
I doubt that your Excel version supports the TEXTSPLIT function, but if you can get your hands on a more modern version this should work to split the text in B1 (similar for the others):
=TEXTSPLIT(B1,,CHAR(10),TRUE)
Otherwise I'd use Power Query as demonstrated in the attached file for C1.
Hi Riny- Can you post the step by step instructions on how you did Power Query for Cell C26
Have you worked with PQ before? If not, a 'step-by-step' may not be very helpful. But, in the example I gave, I connected PQ to the a table with just one row and one column containing only the text that I copied from C1.
And then I had PQ split the cell into rows based with "#(lf)" as the delimiter. This is the code used in PQ to indicate a line feed. In Excel, that would be a CHAR(10).
