Results 1 to 5 of 5

Pull Text Between two characters

Threaded View

  1. #1
    Registered User
    Join Date
    04-18-2020
    Location
    Prince Rupert, B.C.
    MS-Off Ver
    2016
    Posts
    2

    Pull Text Between two characters

    Hi All,

    Im trying to pull out text between two characters.

    This is the text in A1

    \A1;Intersection\P11111th Avenue East & Bill Street\P\PAREA: 815.105m{\H0.7x;\S2^;}

    I need to pull out everything between \P & \P

    So In cell A2 I need to see 11th Avenue East & Brett Street.

    Any help would be greatly appreciated.
    Last edited by JordanJS-1; 04-18-2020 at 02:22 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Pull from between two characters
    By Jietoh in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-21-2016, 12:09 PM
  2. [SOLVED] Pull first numeric characters
    By makinmomb in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-09-2015, 04:07 AM
  3. vba code to pull first two characters
    By bjcowen9000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-15-2013, 01:54 PM
  4. Need to Pull 2 diffrent sets of characters from cell
    By Runamuck in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-11-2013, 07:03 PM
  5. Replies: 3
    Last Post: 04-05-2012, 04:58 PM
  6. pull characters from within text
    By screenpath in forum Excel General
    Replies: 5
    Last Post: 11-11-2007, 08:17 AM
  7. How do I pull just the numeric characters in a cell?
    By punter in forum Excel General
    Replies: 4
    Last Post: 08-01-2006, 04:49 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