How do I extract multiple values from a cell in Excel

[Adilco]

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

[#2 · Accepted solution]

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 

[#3]

@Adilco Use TEXTSPLIT() function.

=TEXTSPLIT(A1,";")

[#4]

@Martin_Weiss .
Thank you. It worked!

[#5]

Thank you. It worked!