Dear JP,
Please see the attached sheet.
Now we can separate
Baddi to Sunder Nagar
or
Sunder Nagar to Baddi
Please check and revert
On Wed, Jul 11, 2012 at 5:20 PM, Jayaprakash S
wrote:
> Dear Masters,
>
> Greetings!!
>
> Could you please help me to split the Text thruough a Formu
Dear Jp.
find the attachment...
i hope it will help you..
Regard
Manoj
On Wed, Jul 11, 2012 at 5:38 PM, Jayaprakash S
wrote:
> Dear Deba Rajan Sir,
>
> thank you... Your formula is working fine except for
>
> "Baddi to Sunder Nagar" Case..
>
> Any updation in your formula
>
> thank you.
>
Dear Jaya,
You can also use:-
First Word:-
=IFERROR(LEFT(A3,FIND(" ",A3,1)),"")
Second word-
=TRIM(IFERROR(LEFT(RIGHT(A3,LEN(A3)-FIND(" ",A3,1)),FIND("
",RIGHT(A3,LEN(A3)-FIND(" ",A3,1,""))
Third word:-
=RIGHT(A3,LEN(A3)-FIND("#",SUBSTITUTE(A3,"
","#",LEN(A3)-LEN(SUBSTITUTE(A3," ","")
Dear Masters,
Greetings!!
Could you please help me to split the Text thruough a Formula for the
attached example...
Thank you.
JP.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, For
