+ Reply to Thread
Results 1 to 8 of 8

Move all text containing ABC to Cell A1 separated by ,

  1. 04-29-2021, 02:47 PM #1
    rolive
    rolive is offline
    Registered User
    Join Date
    04-04-2014
    Location
    Buenos Aires, Argentina
    MS-Off Ver
    Excel 2001
    Posts
    13

    Move all text containing ABC to Cell A1 separated by ,

    Help!!! i'm really failing on this matter.

    I need All Text in column B2 that contains abc, to be copied separeted with commas to column D3.

    Can this be done? Thanks in Advance!!!!
    Reply With QuoteRegister To Reply
  2. 04-29-2021, 02:51 PM #2
    Limor_OP
    Limor_OP is offline
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Move all text containing ABC to Cell A1 separated by ,

    Hi
    You didnt attach any file....
    Reply With QuoteRegister To Reply
  3. 04-29-2021, 03:17 PM #3
    rolive
    rolive is offline
    Registered User
    Join Date
    04-04-2014
    Location
    Buenos Aires, Argentina
    MS-Off Ver
    Excel 2001
    Posts
    13

    Re: Move all text containing ABC to Cell A1 separated by ,

    Sorry, my bad!

    https://docs.google.com/spreadsheets...it?usp=sharing
    Reply With QuoteRegister To Reply
  4. 04-29-2021, 03:23 PM #4
    Limor_OP
    Limor_OP is offline
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: Move all text containing ABC to Cell A1 separated by ,

    Thanks, and what do you mean separated by commas?
    can you give an example?
    Reply With QuoteRegister To Reply
  5. 04-29-2021, 03:23 PM #5
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,206

    Re: Move all text containing ABC to Cell A1 separated by ,

    Can you update your Profile with your Excel version as I am sure it is not 2001!
    Reply With QuoteRegister To Reply
  6. 04-29-2021, 03:27 PM #6
    rolive
    rolive is offline
    Registered User
    Join Date
    04-04-2014
    Location
    Buenos Aires, Argentina
    MS-Off Ver
    Excel 2001
    Posts
    13

    Re: Move all text containing ABC to Cell A1 separated by ,

    7862.0.jpg,
    7862.1.jpg,
    7862.2.jpg,

    Like this. I made one by hand, but im looking for a formula in order to save time.
    Reply With QuoteRegister To Reply
  7. 04-29-2021, 03:32 PM #7
    rolive
    rolive is offline
    Registered User
    Join Date
    04-04-2014
    Location
    Buenos Aires, Argentina
    MS-Off Ver
    Excel 2001
    Posts
    13

    Re: Move all text containing ABC to Cell A1 separated by ,

    https://docs.google.com/spreadsheets...it?usp=sharing

    I uploaded to Drive since im not being able to attach files... not my day,,,
    Reply With QuoteRegister To Reply
  8. 04-29-2021, 03:34 PM #8
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Move all text containing ABC to Cell A1 separated by ,

    How about
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    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. How to move a name separated by , into two columns
    By MarilynBR in forum Excel General
    Replies: 2
    Last Post: 10-21-2015, 12:35 PM
  2. Search cell for multiple text , return comma separated text in separate cell if found
    By dangerdoug in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-01-2013, 01:52 PM
  3. [SOLVED] Formula to Extract Phrase in Cell to Comma Separated Text
    By ghoneim in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-04-2013, 09:44 AM
  4. Vlookup pulling two cells or more of text into one cell separated by a comma
    By ThePainter in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-16-2013, 08:14 PM
  5. how do I move two separated cells to new spreadsheet
    By church lady in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-21-2006, 12:40 PM
  6. [SOLVED] how do I move two separated cells to new spreadsheet
    By church lady in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-21-2006, 12:35 PM
  7. how do I move two separated cells to new spreadsheet
    By church lady in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-21-2006, 12:32 PM

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