Moving characters in between {} into multiple columns

Try this -

Data >> Text To Columns >> Delimited >> Other >> {

See if it works.

Then Find all { & } & Replace with ""

Deep

In C1 type

=MID($B1,FIND("{",$B1)+1, FIND("}",$B1)-FIND("{",$B1)-1)

In D1 type

=MID($B1,FIND("{",$B1,FIND(C1,$B1))+1, FIND("}",$B1,FIND(C1,$B1)+ LEN(C1)+1)-FIND("{",$B1,FIND(C1,$B1))-1)

and drag D1 across to adjacent columns

Another way
In C2, drag across as required, until blanks are returned

Formula:

Please Login or Register  to view this content.