Excel 2007 : Parse string of text from one cell

**ssim** · 02-19-2009, 11:16 PM

I have the path for some of my data in column A and it ends with a back slash "\". I have been trying to find a way to start at the right of a cell and backtrack to the second occurrence of this and extract the text up to right until you hit the next/last occurrence of it. I have attached a sample spreadsheet with sample data and the desired result.

I have spent a few hours trying to nail this one down and searched all the help and forums that I can find.

Any assistance would be greatly appreciated.

**protonLeah** · 02-20-2009, 01:53 AM

Here's a small user function to search from the end of the string:
USAGE:
Given a path in cell B4, then in C4: "=GetFolder(B4)"

Please Login or Register  to view this content.

**DonkeyOte** · 02-20-2009, 05:02 AM

An approach using native formulae:

Please Login or Register  to view this content.

An alternative UDF:

Please Login or Register  to view this content.

Called from cell

Please Login or Register  to view this content.

**ssim** · 02-20-2009, 11:12 AM

Thank you both. Your help is greatly appreciated.

Excel 2007 : Parse string of text from one cell

LinkBack

Thread Tools

Rate This Thread

Display

Parse string of text from one cell

Re: Parse string of text from one cell

Re: Parse string of text from one cell

Solved Re: Parse string of text from one cell

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions