Forum Discussion
Solved
How do I extract multiple values from a cell in Excel
Hi I hoop somebody can help me. I want to extract 4 values from a cell in Excel. The desired return should bel like : Cell A1 contains: BVG;Berlin;MOTO;2125 Desired reusult: Cell B1 = BVG Cell C...
Hi Adilco
there are several option. One would be "Text to Columns"
Step 1:
Step 2:
Step 3:
If you use Microsoft 365 with the latest updates, you could also use the brandnew TEXTSPLIT function:
Just enter the formula in cell B1, it will spill automatically to the other cells
Hi Adilco
there are several option. One would be "Text to Columns"
Step 1:
Step 2:
Step 3:
If you use Microsoft 365 with the latest updates, you could also use the brandnew TEXTSPLIT function:
Just enter the formula in cell B1, it will spill automatically to the other cells
Martin_Weiss .
Thank you. It worked!