Results 1 to 2 of 2

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

Threaded View

  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
« 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