Results 1 to 4 of 4

Powey Query - Extract Text

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-10-2020
    Location
    New Zealand
    MS-Off Ver
    365 personal
    Posts
    306

    Powey Query - Extract Text

    HI

    I need to extract the Age of people. the age occurs after the colon.

    Blank Rows can be ignored but rows with text prior to the colon need to be included.

    The result I want with blank rows is shown

    Would I use a split in a Custom Column?

    Thank you

    Allister
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 8
    Last Post: 10-21-2020, 03:02 AM
  2. Power Query - Extract specific data from text and concatenate with delimiter
    By Riahon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-03-2020, 11:58 AM
  3. [SOLVED] SQL - query on excel cells rather than write the query text?
    By ropbasuel in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-12-2020, 12:35 PM
  4. Extract web query parameter
    By blueballoon9 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2018, 10:29 AM
  5. User for to query/extract data?
    By JKoo1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-21-2013, 07:49 AM
  6. Web query to extract javascript
    By cmb80 in forum Excel General
    Replies: 1
    Last Post: 01-16-2013, 10:29 AM
  7. Web Query Help? - Query Picture Title or Alt Text on a webpage?
    By teamtrav in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-23-2012, 06:33 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