Find text in N columns and one Row

C

Carpe Diem

Hi,

I have the following data in a sheet :

A B C D E F
iglo iol
iglo sapo
iglo aeiou
iglo mf
iglo af

I would like to put in "G" (for each row) column the text between
Column B and Column C.

Example G2 = IOL, G3= Sapo. There is only a value for each row


Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find in a sentence diferent word 1
Find more than a word in a table 3
Getting a formula to reflect added columns 10
Help with lots of formulas 3
Combine text under different condition 3
series of formulas to get to one formula 0
Copying formulas across columns 2
Excel VBA macro, search - accumulate - delete original 0

Top