+ Reply to Thread
Results 1 to 5 of 5

Seprate value

  1. #1
    Registered User
    Join Date
    07-17-2012
    Location
    Delhi
    MS-Off Ver
    Excel 2007
    Posts
    61

    Seprate value

    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

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Seprate value

    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: copy to clipboard
    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

  3. #3
    Forum Contributor satputenandkumar0's Avatar
    Join Date
    11-08-2012
    Location
    Pune, India
    MS-Off Ver
    Office xp & Office 2007
    Posts
    398

    Re: Seprate value

    or try

    Please Login or Register  to view this content.
    Regards,
    Nandkumar S.
    ---------------------------------------------------------------
    Don't forget to Click on * if you like my solution.

  4. #4
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Seprate value

    Try this:

    =MID(A1,SEARCH("(",A1,SEARCH("(",A1,1)+1)+1,SEARCH("Rs",A1,1)-SEARCH("(",A1,SEARCH("(",A1,1)+1)+1)

  5. #5
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Seprate value

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to seprate address
    By mohan.r1980 in forum Excel General
    Replies: 4
    Last Post: 07-04-2014, 09:00 AM
  2. Cell to be seprate
    By mubeenfz143 in forum Excel General
    Replies: 3
    Last Post: 02-22-2012, 04:25 AM
  3. Excel 2007 : Seprate cell same row
    By mubeenff in forum Excel General
    Replies: 2
    Last Post: 06-12-2011, 07:03 AM
  4. Seprate set of numbers in to different Category
    By metricspace in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 07-10-2009, 01:51 PM
  5. seprate and store string in arrays
    By ilyaskazi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-29-2005, 10:22 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1