+ Reply to Thread
Results 1 to 2 of 2

CONCAT in one specific Line if value dosne't contain an specific value

  1. 05-15-2019, 04:53 AM #1
    mismcv
    mismcv is offline
    Registered User
    Join Date
    05-15-2019
    Location
    spain
    MS-Off Ver
    10
    Posts
    1

    CONCAT in one specific Line if value dosne't contain an specific value

    Hello,

    I have all the data in the same column, but I need to keep just one value in the column and then all the other values that contain ".jpg" move it to the seocnd column.

    See data attached.

    Do you know any formula that help me to do it quick?

    thanks!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-15-2019, 11:29 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: CONCAT in one specific Line if value dosne't contain an specific value

    Hi, welcome to the forum

    Formulas cannot "move" data to anywhere, they only affect the cell they reside in. You would probably need VBA for this.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    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. Extract a specific line from a excel cell (containing multi line text)
    By anonymous321 in forum Excel General
    Replies: 14
    Last Post: 12-31-2023, 01:53 AM
  2. [SOLVED] concat values and count values for each specific id
    By soli004 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-08-2018, 06:13 AM
  3. To paste specific data in specific columns and rows to specific table in powerpoint
    By ell_ in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-20-2017, 02:09 AM
  4. line transfer of data to same sheet but on line 50 using 1 of 3 specific cells same line
    By Elvis007 in forum Hello..Introduce yourself
    Replies: 3
    Last Post: 03-12-2017, 03:39 PM
  5. [SOLVED] Export Subject Line from specific email to specific excel spreadsheet
    By ShakJames in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 09-12-2016, 03:55 PM
  6. Move line with specific val to new sheet even if the value appears on diff line each time.
    By sparty911 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-05-2013, 03:40 PM
  7. Macro to copy specific line from text file and paste into specific cell in excel
    By keeneye in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2013, 10:35 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