+ Reply to Thread
Results 1 to 2 of 2

Google Sheets Formula help to extract a string value

  1. #1
    Registered User
    Join Date
    06-17-2020
    Location
    Canada
    MS-Off Ver
    2019
    Posts
    27

    Google Sheets Formula help to extract a string value

    Looking for help with a formula for this sheet— https://docs.google.com/spreadsheets...it?usp=sharing


    Please refer to the sheet called "reference platform/placement"

    This sheet essentially pulls the info that's from platform/placement (the data here is pulled from Supermetrics, so it's not to be touched)
    I'd like a formula in Column B and Column C of "reference platform/placement" to output a certain term if it meets requirements. I have an example of my desired output in B & C in columns L and M.

    For Column B, i'd like it to extract the word that is before the first "|" symbol in Column C. For example, if Column C says, "instagram|instagram_stories|mobile_app", i'd like Column B to say "Instagram"

    For Column C, (placement), i'd like it to just spit out "in-feed" if the string of text contains "feed" OR "feeds" i'd like the value to return "in feed". similarly if the string of text contains "instagram_stories" i'd like it to spit out "Instagram stories"

    Appreciate any help i can get. also, if it doesn't make sense to have a formula in Column B/C i'm also open to having it in another column.

    Thank you!

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,535

    Re: Google Sheets Formula help to extract a string value

    Selecting the link results in the following: "Not Found Error 404".
    Could you put a sample of the data into an Excel file and upload it directly (utilizing the instructions in the banner at the top of the page)?
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Google Sheets Duplicate Nth Character and/or Vowel in a string.
    By antonyx in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 01-10-2022, 11:52 AM
  2. Google Sheets. Can I connect offline data from excel to google sheets?
    By drlemur39 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 11-15-2021, 10:40 AM
  3. [SOLVED] Extract from Google Sheets into Excel
    By Frenchie76 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-16-2021, 08:42 AM
  4. dynamic formula to count through existing and new sheets(In google sheets)
    By wlinksanju in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 11-26-2020, 09:16 PM
  5. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  6. [SOLVED] Formula to search a range for a string and then extract certain dta from string
    By gratedane8 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-08-2018, 06:09 PM
  7. Formula to extract data from Google?
    By tpir72 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-10-2012, 06:16 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1