Using mid to return txt of diffent lenths from block txt

[Notters]

Hi there i wasnt to split a written address out into its componant parts and populate them in seperate columns. I know how to use left right and mid to do this if the txt is the same lenth but is there anyway i can get it to use spaces to then work out how many charictors to return per cell?

Please see the attached example.

Thanks

[Pete_UK]

You can use SEARCH or FIND to get the position of the commas, and so you use this within each LEFT, RIGHT or MID function. I'll put something together in your workbook and get back to you.

Hope this helps.

Pete

[Notters]

Thanks Pete, that would be amazing!

[Pete_UK]

I've put the appropriate formulae in the attached workbook, for up to 4 address lines plus a postcode. For it to work correctly, there must be at least two address lines, a postcode at the end, and commas must separate each part of the address - you had full-stops in a couple of places.

Hope this helps.

Pete

[Notters]

Thanks for all your help on this