Ask Experts Questions for FREE Help !
Ask
    NS_DINESH's Avatar
    NS_DINESH Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Mar 19, 2012, 04:14 AM
    How to take the informations in brackets separate from a huge worksheet?
    How to take the informations in brackets separate from a huge worksheet?

    Being bank transfer received ( mrdf38/b-5)
    Rent deposited ( hac514 & 515 )
    Being rectification entry passed due inappropriate rent allocation for the year 2011 & 2012 as per (jv 7913).
    Being rent from jv1/71 deposited
    Being rent deposited ( mrb-701 )
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Mar 20, 2012, 04:51 AM
    If those text strings are in A1, A2, A3, etc.. Put this formula in B1 and copy down:

    =TRIM(MID(A1, FIND("(", A1)+1, FIND(")", A1)-FIND("(",A1)-1))

    You will get errors on the rows with no bracketed info.

    To avoid the errors you can use:

    =IF(ISNUMBER(SEARCH("(",A1)), TRIM(MID(A1, FIND("(", A1)+1, FIND(")", A1)-FIND("(",A1)-1)), "")
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Two dwarf hamsters have died 6 months old separate cages separate rooms [ 4 Answers ]

I have tonight found my two white dwarf hamsters dead in their cages. They are in separate cages in separate rooms.I have only had them 6 months - I had to separate them after about a month as they were fighting. They were in large plastic rotastak cages - loads of room each - in separate rooms...

How to wire 3 separate lights to 3 separate switches in series circuit [ 1 Answers ]

I am running wire from the circuit panel to the ceiling in the kitchen, then to a switch, back to the kitchen ceiling light. I am using the same circuit to the same thing for the dining room light with a switch, and a light on my deck also with its own switch. The switch in the dining room and the...

Military informations [ 1 Answers ]

To who it may concern, my name is hosanna Omoghene Nigerian by birth I really need help and assistance in joining the US army as any Aviator . I will really prefer informations based on fort rucker in Alabama... My email address is [email protected]

I need Informations! [ 1 Answers ]

Hi every body I'm tunisian and I got married with english women 10 days ago and I want to join my wife there in england but the problem I don't know what the documents for can I get a visa for go to england please if there who knows about that just give me help cz I want be with my wife and tanks...

Informations about NTFS [ 1 Answers ]

Haw can I set NTFS permisssion in winxp Home Edition?

View more questions Search