Hi,

I'm currently working on the following:

Cel A1 says "3456 AA Utrecht ERDS". I want to split this into
1. 3456 AA
2. Utrecht
3. Old

Is there a formula for splitting cel A1 into these 3 parts. If Yes...Is this
formula also working when cel A2 says "3455 DF Amsterdam ERDSERTR"

thx