excel_2009
Active Member
- Joined
- Sep 14, 2009
- Messages
- 318
hi excel gurus,
I've the following issue and was wondering if someone could help me. I have a column full of text and numbers, all i want to do is keep all the numbers which are in a bracket. sample data:
spiderman
batman101
peter(101)
and all i'll be left with on the sheet would be (101)
can someone please help?
I have this subsitute forumla but cannot for the life of me figure out how to adapt to my needs:
Thank you
I've the following issue and was wondering if someone could help me. I have a column full of text and numbers, all i want to do is keep all the numbers which are in a bracket. sample data:
spiderman
batman101
peter(101)
and all i'll be left with on the sheet would be (101)
can someone please help?
I have this subsitute forumla but cannot for the life of me figure out how to adapt to my needs:
Code:
=SUBSTITUTE(A1," "&LEFT(A1,LEN(A1)-SEARCH("@#",SUBSTITUTE(A1," ","@#",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))),"")
Thank you
