Find a text string and partially index it

**royalB** · 08-01-2014, 08:29 AM

Hi there, could someone please help me? I would like to find a text string in the column A and index the value after the string.

For example: somewhere in the column A is a text "value: 800 USD" , so I would like to find the text and index the characters after the ": " in the cell C5. Therefore in the cell C would be "800 USD"

I am including sample file here: smpl.xlsx

Any help will be appreciated. Thank you.

**Ace_XL** · 08-01-2014, 08:33 AM

Try

=SUBSTITUTE(INDEX(A:A,MATCH("*value:*",A:A,0)),"value: ",)

Find a text string and partially index it

LinkBack

Thread Tools

Rate This Thread

Display

Find a text string and partially index it

Re: Find a text string and partially index it

Thread Information

Users Browsing this Thread

Similar Threads

Printing a word document partially in Black and White and partially in color

Index with Multiple criteria and Partially defined date ranges.

[SOLVED] Find partial text string within another text string return original text into cell.

[SOLVED] Find String of Text Plus Cell Index Color

Find String of Text Plus Cell Index Color

Bookmarks

Bookmarks

Posting Permissions