Find Text in Excel

[beetlejuicee]

How can i locate the text in excel by formula ?

For instance:

A1 = FUN

B1 = FOR

C1 = FAR

D1 = CAR

E1 = JAR


I wanna find out where the text "Car" is found (returned by formula). Even column name is enough?

[zbor]

Use

Please Login or Register  to view this content.

[beetlejuicee]

it just returns numeric value which is column number. I need alphabetic letter ?
Regards,

[Kyle123]

Please Login or Register  to view this content.

[beetlejuicee]

I really appreciate your speedy efforts. I need last answer.


char.jpg

I need to get column letter where "Grand Total" is located. But +64 or other versions dont supply it correctly ?

[Special-K]

Maybe

=MID(ADDRESS(2,MATCH("xxx",A1:ZZ1,0)),2,LEN(ADDRESS(2,MATCH("xxx",A1:ZZ1,0)))-3)

[Kyle123]

This feels suspiciously like an XY problem (http://xyproblem.info/) what are you actually trying to do?

[zbor]

if Grand Total is last column this will return last column of no matter what:

Please Login or Register  to view this content.

In your case result is: $CD$1

Change 1 to get other row

[beetlejuicee]

This worked flawlessly

char.jpg

Thanks to Special-K

zbor i m also trying your formula