+ Reply to Thread
Results 1 to 7 of 7

I Need to pick some word or text in one coloum to another coloum

  1. 12-27-2018, 05:51 AM #1
    Blek
    Blek is offline
    Registered User
    Join Date
    12-27-2018
    Location
    Indonesia
    MS-Off Ver
    2016
    Posts
    27

    Wink I Need to pick some word or text in one coloum to another coloum

    EXCEL FORMULA SIZE.jpg

    As you can see at the picture. Can someone help me what's the formula for this kind situation? I need Grab that XS,S,M,L,XL,XXL to other coloum.

    Sample Link.
    www(dot)drive(dot)google(dot)com/open?id=1VZ9jQu7tIYwLLCeN--vBLbFbKT6HAMaZ

    Thank You. Glad found this Forum.


    * I Can't attach file, this is weird. xD. So i put Sample Link at Google Drive. [ Change (dot) with . ]
    Last edited by Blek; 12-27-2018 at 09:29 AM. Reason: Problem is SOLVED
    Reply With QuoteRegister To Reply
  2. 12-27-2018, 07:12 AM #2
    xjohnson
    xjohnson is offline
    Banned User!
    Join Date
    10-12-2018
    Location
    Texas
    MS-Off Ver
    2010
    Posts
    358

    Re: I Need to pick some word or text in one coloum to another coloum

    Maybe try text to columns deliminated.

    To attach file Go Advanced then scroll down to Manage Attachments.
    Reply With QuoteRegister To Reply
  3. 12-27-2018, 07:56 AM #3
    Blek
    Blek is offline
    Registered User
    Join Date
    12-27-2018
    Location
    Indonesia
    MS-Off Ver
    2016
    Posts
    27

    Re: I Need to pick some word or text in one coloum to another coloum

    Quote Originally Posted by xjohnson View Post
    Maybe try text to columns deliminated.

    To attach file Go Advanced then scroll down to Manage Attachments.
    Yes, How to deliminated? In my situation how to do that?
    And still, can't attach file. Tried 4 Different Browsers with off Adblock (Chrome, Mozilla, Edge, Centbrowser) Nothing works.


    Thank you for reply.
    Reply With QuoteRegister To Reply
  4. 12-27-2018, 08:07 AM #4
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: I Need to pick some word or text in one coloum to another coloum

    Please try at B2 Press Ctrl+Shift+Enter and copy down

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
  5. 12-27-2018, 08:42 AM #5
    Blek
    Blek is offline
    Registered User
    Join Date
    12-27-2018
    Location
    Indonesia
    MS-Off Ver
    2016
    Posts
    27

    Re: I Need to pick some word or text in one coloum to another coloum

    Quote Originally Posted by Bo_Ry View Post
    Please try at B2 Press Ctrl+Shift+Enter and copy down

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Wow it's working, thank you thank you thank you very much!

    One more thing, if you don't mind. Can you add Text "Other" instead blank Coloum if theres no any XS,S,M,L,XL,XXL in coloum. What should i add in the formula?

    Blank Formula.jpg
    Reply With QuoteRegister To Reply
  6. 12-27-2018, 09:19 AM #6
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: I Need to pick some word or text in one coloum to another coloum

    Try this with CSE

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 12-27-2018, 09:27 AM #7
    Blek
    Blek is offline
    Registered User
    Join Date
    12-27-2018
    Location
    Indonesia
    MS-Off Ver
    2016
    Posts
    27

    Re: I Need to pick some word or text in one coloum to another coloum

    Quote Originally Posted by Bo_Ry View Post
    Try this with CSE

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    You are my savior!!! Once Again, Thank You So Much! You are the best! :D All works like a charm, perfect!

    Thank you for helping, i love this forum :D
    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. [SOLVED] same text in row need coloum wise
    By sharadmaxwell in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-04-2018, 01:14 AM
  2. Copy rows if specific text in coloum A
    By superking in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-27-2014, 03:52 AM
  3. Copy rows if specific text in coloum A
    By superking in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-27-2014, 03:10 AM
  4. [SOLVED] Macro to Seach word and color the row till G coloum.
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-29-2013, 02:56 PM
  5. text to coloum
    By arnab0711 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-28-2008, 04:26 PM
  6. text to coloum
    By bahadirakcan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-19-2006, 02:34 AM
  7. [SOLVED] i want display the last coloum value in first coloum
    By sajid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2006, 11:15 AM

Tags for this Thread

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