Extract parameters from a string of text

Hi guys,

I'm trying to find a formula which in essence is the same as 'text to columns'.

I'll be pasting in post strings such as: A=B&C=D&E=F etc etc.

I need a formula to break the url so i have all the individual parameters listed i.e

A=B
&C=D
&E=F

Can this be done without a macro? Also i'm not fussed where the '&' belongs either at the front or the end of the text string.

Thanks in advance,
Lloyd

Hi Benishiryo,

Thanks for the quick reply!

It works to a degree, it is chopping some parameters though - i'll explain in more depth hopefully it will help.

In cell A1 i will paste a string similar to:

url=www.test.com/sale&value=100&ordertime=20.14&delivery=test_test_test_test

Either below or alongside i'd like to see:

url=www.test.com/sale
&value=100
&ordertime=20.14
&delivery=test_test_test_test

The parameter length can vary though between 5-10 chars and 9999 chars.

Again thanks for your help,
Lloyd

Hi,

There are hundreds of the 'text=text' combinations but yes they are always split by a &.

Thanks,
Lloyd