Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find text in N columns and one Row
one way. copy down
=INDEX(2:2,0,MATCH("zzz",A2:F2)) On Nov 30, 6:00*am, Carpe Diem wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
find text in cell and replace it with part of the text in that ce. | Excel Discussion (Misc queries) | |||
How to find and highlight common text in multiple columns | Excel Discussion (Misc queries) | |||
can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
Linking text columns with text and data columns | Excel Worksheet Functions |