Seperating data / Opposite of concatenate

C

coolioi

New Member
Joined
Jul 16, 2012
Messages
1
I have the following information all stored in 1 cell. and i have 100 of these!


Amraser Straße 6 6020 Innsbruck Einzelhandel mit Lebensmitteln; Großhandel mit Lebensmitteln; Großhandel mit Obst, Gemüse; Marktfahrer; Export-,Import-,Transithandel Folgende Kontaktdaten sind vorhanden: Biozertifizierung durch eine akkred 0043 512 52015 0043 512 5201515 Web www.ischia.at

I would like the information to turn out similar to this!

Amraser Straße 6 6020 Innsbruck Einzelhandel mit Lebensmitteln
Großhandel mit Lebensmitteln
Großhandel mit Obst, Gemüse
Marktfahrer
Export-,Import-,
Transithandel Folgende Kontaktdaten sind vorhanden: Biozertifizierung durch eine akkred
0043 512 52015 0043 512 5201515
Web www.ischia.at


Its in German but as you can see in the beginning each category is seperated by a ; then a , then a space. So im kinda confused figuring out which functions to use to separate the cells. Im pretty sure that i need to split the line first because not all are seperated by semi colons or commas!
Anyways would be a great help if somebody can help me solve this puzzle!
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Sort by date Sort by votes
How would you determine which commas to split on and which to ignore?
 
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,214,819
Messages
6,121,749
Members
449,050
Latest member
excelknuckles

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top