PDA

View Full Version : String with String



Chandrasheka
09-22-2010, 06:22 AM
Hi,

I to extract string within string. I have attached excel file please let me know how to do it using excel formula.

Thanks
Chandra Shekar

lynnnow
09-22-2010, 06:52 AM
=MID(A2,SEARCH("of ",A2,1)+3,LEN(A2))

p45cal
09-22-2010, 06:57 AM
Chandrasheka, if you must cross post, please have the courtesy to tell others everywhere you have done so.
So far:http://www.mrexcel.com/forum/showthread.php?t=496545
…anywhere else?

Chandrasheka
09-22-2010, 07:09 AM
Hi,

I am not getting desired result again I am attaching file. Please do the needful.

Thanks

Aussiebear
09-22-2010, 06:01 PM
Hi,

I am not getting desired result again I am attaching file. Please do the needful.

Thanks

Do you understand what we mean by posting a link when you have the need to cross post?

Chandrasheka
09-23-2010, 12:37 AM
Hi,I am new to excel please let me know what it is.ThanksChandra Shekar

GTO
09-23-2010, 12:42 AM
Greetings Chandrasheka,

Cross-posting is when you post the same problem in different forums. I think that this is an awfully nice explanation--->Here (http://www.excelguru.ca/node/7)

If you have any questions after clicking on the link and reading the article, please do not hesitate to ask :-)

Hope that helps,

Mark

Chandrasheka
09-23-2010, 05:07 AM
Hi,

I am extremely sorry for that.

Regards,

Chandra Shekar