Forum Discussion
Excel - Extraction of content from a cell
Hello all, I am new to this community. I would love to have your help on the following question : - I have an Excel sheet with a serie of numbers, always starting by the number "3". - Each ...
Hello Iovan,
unfortunately you did not show the desired result. So my guess would be this:
Change the list into an Excel table (CTRL-T).
Goto Data -> Get and transform -> From Table
Now you are inside the query editor.
Change the data type to Text.
Split column by delimiter: #(lf)
Split into Rows.
Change data type to number.
Close and load.
Done.