Closed Thread
Results 1 to 4 of 4

Trying to pull a few values out of a text string - Stuck!

  1. #1
    Registered User
    Join Date
    03-15-2010
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    7

    Trying to pull a few values out of a text string - Stuck!

    Hi - so I am trying to figure out the best way to pull out certain data from this excel sheet into a new clean column.
    Basically...
    - Column B (Asset Description) has a string of notes/text
    - Some of these notes include a percentage and date that I need to pull out
    - Of course they are not in a conformed order so was trying to do like Left/Rights etc. but couldn't figure out how to just pull out "if text has a %, then return that percent" type of thing.

    - Example is... "7% Price increase effective 1/1/23 5% price increase, effective 1/1/22"
    - I am trying to create a new column with Price Increase % and a new column with the date.

    What are my options here? Is it a macro or something simple I am not thinking of!
    Any help is so appreciated!!
    Attached Files Attached Files
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,926

    Re: Trying to pull a few values out of a text string - Stuck!

    You are not allowed to have duplicate threads in this forum - you can read the forum rules by clicking on the upper-most menu bar above.

    Pete

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2407 Win 11 Home 64 Bit
    Posts
    24,134

    Re: Trying to pull a few values out of a text string - Stuck!

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #2 about thread duplication.

    I am closing this thread, but you may continue here in the original thread:https://www.excelforum.com/excel-programming-vba-macros/1411163-stuck-excel-pulling-string-out-of-text-to-create-new-columns.html
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2405
    Posts
    25,133

    Re: Trying to pull a few values out of a text string - Stuck!

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #2 about thread duplication.

    I am closing this thread, but you may continue here in the original thread

    If you ever want to change the category of a question, do not post a duplicate. Click Report under your post and request that we move it for you.

    Thread closed.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Stuck! Excel pulling string out of text to create new columns
    By helpwithexcel1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2023, 09:42 PM
  2. pull number string from a text box
    By ayeshamosharraf in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-04-2017, 02:37 PM
  3. Stuck on a IF function and text return based on values
    By Cedric Wyckmans in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-19-2017, 07:06 AM
  4. Function to pull out text from a string
    By kenadams378 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-19-2015, 07:02 AM
  5. pull values from string in a range
    By fraeza in forum Excel General
    Replies: 0
    Last Post: 02-28-2015, 02:26 AM
  6. [SOLVED] Pull numeric value from text string.
    By Sam Capricci in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-05-2013, 02:03 PM
  7. Advanced Split Function: Need to pull text string in quotes, within a text string
    By Zamboni in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-27-2013, 04:38 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1