View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carpe Diem Carpe Diem is offline
external usenet poster
 
Posts: 28
Default Find text in N columns and one Row

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