[b]How to Extract Txt from 1st List Based on Txt in 2nd List[/b]

[johnfrani]

I have two columns in an Excel spreadsheet.

The first (A1:A10) has all possible text values (abcdef) in each cell.

Each cell in the second column (B1:B10) has only one of the possible text letters (ex. b in cell B1).

I am looking for an Excel formula (or some technique)
that will allow me to create a third column (C1:C10) that the formula will populate with all the possible text values from column A EXCEPT for the text value in the same row of column B.

Example
Col A ColB ColC
abcdef b acdef
abcedf f abcde

Thanks
John

 

[SkipVought]

Hi,

This question has been answered many times in this forum.

Also check out

http://www.contextures.com/tiptech.html.

Skip,
[sub]
[red]Sign above the facsimile apparatus at the music publisher:[/red]
If it ain't baroque...
Don't FAX it![/sub]

 

[johnfrani]

Thanks for the link, Skip but I couldn't find this topic addressed there. I also spent a lot of time searching at tek-tips and other sites with negative results. I'm probably not phrasing my search correctly.

What should I search for?

Thanks
John

 

[Gavona]

Have a look at the Substitute function.

Thanks,

Gavin

 

[SkipVought]

http://www.contextures.com/xlDataVal02.html

Skip,
[sub]
[red]Sign above the facsimile apparatus at the music publisher:[/red]
If it ain't baroque...
Don't FAX it![/sub]

 

[johnfrani]

Thanks, Gavona.
I found my solution with the substitute function.
I just needed the correct term to search for.
John