Extracting multiple text within brackets

[guapo]

Hi
I have a problem getting past this.

I have a single excel cell with the following example in it;

<1234> hsjudfg <3456> cdhjkd <765432>

I wish to extract it into a single cell as follows;
<1234><3456><765432>

Only extracting the brackets and information within.
I tried building a formula as follows but cannot seem to get past extracting only the first <1234> and similarly only mutliple instances of this eg. <1234><1234>

=MID(A1,FIND(CHAR(60),A1),FIND(CHAR(62),A1))&MID(A1,FIND(CHAR(60),A1),FIND(CHAR(62),A1))

Any help truly appreciated
Many Thanks
Guapo

[guapo]

Forgot to mention there maybe any number of <1234> within a cell - probably no more than 30 I guess
And the sizes amount of text can also vary significantly from <1> to <1234567890> etc

Thanks

[FDibbins]

assuming your data is in A!, try this...
=LEFT(A1,SEARCH(">",A1,1))&MID(A1,SEARCH("<",A1,SEARCH(">",A1,1)),SEARCH(">",A1,SEARCH(">",A1,1)))&RIGHT(A1,LEN(A1)-SEARCH("<",A1,SEARCH(">",A1,SEARCH(">",A1,1)+1))+1)

[guapo]

Hi,

Many thanks for this.
I have tried it and unfortunately it does not work - stays on "VALUE"!
I tried it purely on the test data as I posted here.

I will look at your formula and try to figure it out, any further advice greatly received.
Many Thanks
Guapo

[guapo]

Ok got it to work.

It was my mistake, it works for 3 x <1234> in a cell.

However a cell could have only 1 x <1234> or 30 x <1234> in a cell.

If it is less or more than 3 of these, <1234> then it will not function, I probably was not so clear in my original explanation.

Will continue to look to see if I can figure it out

Thanks

[guapo]

These are some cell examples that it needs to work for;

ggggg <test> lkjlkhlk <9090> jkjkjjk<88888>kjkjj<9090>

Result needed: <test><9090><88888><9090>

ggggg <test> lkjlkhlk <9090> jkjkjjk<88888>kjkjj<9090> ggggg <test> lkjlkhlk <9090> jkjkjjk<88888>kjkjj<9090>

Result needed: <test><9090><88888><9090><test><9090><88888><9090>

I have tried but unable to figure it out :-(

Any help welcomed

Thanks

[Marcol]

Probably the most versitile way to do this is with a UDF.

This will clear any amount of characters outwith delimiters < and >

Please Login or Register  to view this content.

Use in Excel

Please Login or Register  to view this content.

See this workbook

[jindon]

UDF

=Guapo(A1)

Please Login or Register  to view this content.

[Pepe Le Mokko]

I'm afraid your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

Cross posted on excelkey.com with different user name

[guapo]

Understood
Apologies for this.
Won't happen again.

I have not tried the fix yet. But a big thanks for the information.
Best
Guano

[guapo]

Thanks to everyone for your help on this, working well. !!