Hi,
Please help me for seperate value as below.
1 The item of (Desktop (500Rs)
2 The item of (Laptop (25000Rs)
In 1 500Rs
2 25000Rs
Sandy
Hi,
Please help me for seperate value as below.
1 The item of (Desktop (500Rs)
2 The item of (Laptop (25000Rs)
In 1 500Rs
2 25000Rs
Sandy
Try this out - it's OK as long as the currency is in Rupees, and are shorter than 9 digits!!! It will need to be modified if others are present...
Formula:Please Login or Register to view this content.
Last edited by Glenn Kennedy; 08-23-2014 at 07:12 AM. Reason: I added the currency units...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
or try
Please Login or Register to view this content.
Regards,
Nandkumar S.
---------------------------------------------------------------
Don't forget to Click on * if you like my solution.
Try this:
=MID(A1,SEARCH("(",A1,SEARCH("(",A1,1)+1)+1,SEARCH("Rs",A1,1)-SEARCH("(",A1,SEARCH("(",A1,1)+1)+1)
Here is your solution
=SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(A1,"(",REPT(" ",255)),255)),")","")
A B 1(Desktop (500Rs) 500Rs 2(Laptop (25000Rs) 25000Rs
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks