Sep 21 2022 11:34 PM
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
Sep 21 2022 11:45 PM
SolutionHi @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
Sep 22 2022 12:16 AM
Sep 23 2022 12:06 AM
@Martin_Weiss .
Thank you. It worked!
Sep 23 2022 12:08 AM
Sep 21 2022 11:45 PM
SolutionHi @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