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 C1= Berlin
Cell D1=MOTO
Cell E1= 2125
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
- Thank you. It worked!
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!
