Celticshadow
Active Member
- Joined
- Aug 16, 2010
- Messages
- 414
- Office Version
- 365
- Platform
- Windows
Hi
How do extract the data using an excel formula from after each = symbol in the below.
In Cell F1 I have,
hcap=Y class=1 racetype=FLT racetype2=Listed
and in cells G1 through to j1 i require the below data
G1 - Y
H1 - 1
I1 - FLT
J1 - Listed
Many thanks in advance.
Regards
How do extract the data using an excel formula from after each = symbol in the below.
In Cell F1 I have,
hcap=Y class=1 racetype=FLT racetype2=Listed
and in cells G1 through to j1 i require the below data
G1 - Y
H1 - 1
I1 - FLT
J1 - Listed
Many thanks in advance.
Regards