+ Reply to Thread
Results 1 to 14 of 14

Data removal from cell

  1. 04-08-2014, 06:00 AM #1
    singer.joseph
    singer.joseph is offline
    Forum Contributor
    Join Date
    02-17-2013
    Location
    israel
    MS-Off Ver
    Excel 2003
    Posts
    106

    Data removal from cell

    Is there a way for example if i have a cell and the data in it is Princess,Princess,Round or Round,Round and a few other shapes that are coming out doubled... is there a way to remove them ? so that the value would be Princess,Round (for the first example) or Just Round (in the second example).

    Your help would be much appreciated.
    Reply With QuoteRegister To Reply
  2. 04-08-2014, 06:14 AM #2
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Data removal from cell

    Hello

    Take a look to this
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
  3. 04-08-2014, 06:31 AM #3
    singer.joseph
    singer.joseph is offline
    Forum Contributor
    Join Date
    02-17-2013
    Location
    israel
    MS-Off Ver
    Excel 2003
    Posts
    106

    Re: Data removal from cell

    Thanks for your quick reply, i saw those. Sorry for not clarifying my question. is there a formula that can do this ? not VBA
    Reply With QuoteRegister To Reply
  4. 04-08-2014, 06:43 AM #4
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Data removal from cell

    In Excel(as in real life too..) Never say Never..but i your case-as i know- the answer is that you have to use VBA for this.
    Reply With QuoteRegister To Reply
  5. 04-08-2014, 06:45 AM #5
    singer.joseph
    singer.joseph is offline
    Forum Contributor
    Join Date
    02-17-2013
    Location
    israel
    MS-Off Ver
    Excel 2003
    Posts
    106

    Re: Data removal from cell

    Thanks for the reply... Maybe someone else has a solution to this.
    Reply With QuoteRegister To Reply
  6. 04-08-2014, 07:00 AM #6
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Data removal from cell

    Quote Originally Posted by singer.joseph View Post
    Maybe someone else has a solution to this.
    I know it cannot be done in inbuilt worksheet functions, but for a safer side me too saying the same, it's very very toughest job because the permutation combination will go very high and can't be done easily with worksheet functions....


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved

    If the suggestion helps you, then Click *below to Add Reputation
    Reply With QuoteRegister To Reply
  7. 04-08-2014, 07:03 AM #7
    singer.joseph
    singer.joseph is offline
    Forum Contributor
    Join Date
    02-17-2013
    Location
    israel
    MS-Off Ver
    Excel 2003
    Posts
    106

    Re: Data removal from cell

    Thanks for the reply... i am going to hold out a bit longer and see if anyone might have a glimmer of hope for me...
    Reply With QuoteRegister To Reply
  8. 04-08-2014, 07:05 AM #8
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Data removal from cell

    Quote Originally Posted by singer.joseph View Post
    i am going to hold out a bit longer and see if anyone might have a glimmer of hope for me...
    We will be very much happy if you get the expected solution with WF and I learn from it too...
    Reply With QuoteRegister To Reply
  9. 04-08-2014, 07:09 AM #9
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Data removal from cell

    Quote Originally Posted by :) Sixthsense :) View Post
    We will be very much happy if you get the expected solution with WF and I learn from it too...

    That's correct. Me too!!
    Reply With QuoteRegister To Reply
  10. 04-09-2014, 04:52 AM #10
    singer.joseph
    singer.joseph is offline
    Forum Contributor
    Join Date
    02-17-2013
    Location
    israel
    MS-Off Ver
    Excel 2003
    Posts
    106

    Re: Data removal from cell

    Attached is the workbook with an example for now of what i am dealing with... all of the data is separated with a "," and no spaces

    Anyone have any ideas of a function that will help me out...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  11. 04-09-2014, 05:26 AM #11
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Data removal from cell

    If you confirm, I am ready to provide UDF solution
    Reply With QuoteRegister To Reply
  12. 04-09-2014, 05:35 AM #12
    singer.joseph
    singer.joseph is offline
    Forum Contributor
    Join Date
    02-17-2013
    Location
    israel
    MS-Off Ver
    Excel 2003
    Posts
    106

    Re: Data removal from cell

    what is UDF ?
    Reply With QuoteRegister To Reply
  13. 04-09-2014, 09:46 AM #13
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Data removal from cell

    User Defined Function (UDF), creating our own functions with the help of VBA. Like vlookup, sum, count etc.,
    Reply With QuoteRegister To Reply
  14. 04-09-2014, 10:02 AM #14
    singer.joseph
    singer.joseph is offline
    Forum Contributor
    Join Date
    02-17-2013
    Location
    israel
    MS-Off Ver
    Excel 2003
    Posts
    106

    Re: Data removal from cell

    Sounds great to me.

    If you think it will work i will be forever greatful
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Please help for Dup Removal and some data processing
    By caabdul in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-17-2013, 07:41 AM
  2. Data Removal after Validation
    By Skiman in forum Excel General
    Replies: 4
    Last Post: 05-12-2012, 09:11 PM
  3. Data removal
    By ukphoenix in forum Excel General
    Replies: 0
    Last Post: 12-08-2011, 11:13 PM
  4. Removal of the data where sum is below 500
    By meetvivek72 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-05-2011, 06:07 AM
  5. Duplicate data removal
    By dawsonsoo in forum Excel General
    Replies: 3
    Last Post: 07-20-2009, 11:29 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1