Dear Prince,
Very Helpful and thanks again providing this helpful knowledge
Amar
On Fri, Jan 18, 2013 at 11:28 AM, Prince wrote:
> Hi Amar,
>
> When we use "*instr*" function it give us the first position of the text
> we want to search in a string for Example:
>
> "Hindustan Times is an India
Hi Amar,
When we use "*instr*" function it give us the first position of the text we
want to search in a string for Example:
"Hindustan Times is an India news paper : 123"
in above string i want to get any word after the Word "Paper" i have to
search word "Paper" first so i will use instr fu
Thank u so much...Prince,Ashish, Excel Beginner for your kind help.I
teaching some from this formula.
Thanks very much friends.But i asked Question Ashish & Prince what is 16
numbers in formula for prince & what is 15 numbers in formula for ashish.
On Thu, Jan 17, 2013 at 10:31 PM, >>Excel Beg
Hi Amar,
Below is the solution to your needs or check the attachment.
=--MID($C$2,SEARCH(B6,$C$2)+(LEN(B6))+3,FIND(,$C$2,SEARCH(B6,$C$2)+(LEN(B6)+3))-(SEARCH(B6,$C$2)+(LEN(B6)+3)))
--
*Regards,*
*
*
*Excel Beginner*
On Thu, Jan 17, 2013 at 7:03 PM, amar takale wrote:
> All Dea
see attachment
On Thu, Jan 17, 2013 at 7:03 PM, amar takale wrote:
> All Dear,
>
> Can you suggest any formula.Pls suggest
> Appreciate the help
>
> Amar
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thr
All Dear,
Can you suggest any formula.Pls suggest
Appreciate the help
Amar
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code
