I am fine buddy.
If it is more than 5 words in a cell how will you extract the right word.
Probably Ashish has sent was the perfect solution for it.
Thanks and Regards,
Anand S
On Fri, May 7, 2010 at 9:49 AM, Vikas Chouhan <vikask...@gmail.com> wrote:
> hi anand how are you............................
>
>
> A B
> 1 vikas kumar =right(A1,LEN(A1)-FIND(" ",A1) RESULT IS "KUMAR"
>
> On Thu, May 6, 2010 at 9:39 AM, P.VIJAYKUMAR <vijay.4...@gmail.com> wrote:
>
>> Use the function RIGHT(Select the whole text in which the textor the thing
>> which you want is there,number of characters which you want from the text)
>>
>> Ex: If a Cell B2 Contains TIGER999 .Use the function = RIGHT(B2,3) to
>> get the required 999 as the answer.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> On Thu, May 6, 2010 at 9:22 PM, ashish koul <koul.ash...@gmail.com>wrote:
>>
>>> Public Function exright(Str)
>>> Dim i, NumStr1
>>> NumStr1 = ""
>>>
>>> For i = Len(Str) To 1 Step -1
>>> If (Mid(Str, i, 1)) <> " " Then
>>> NumStr1 = Mid(Str, i, 1) & NumStr1
>>>
>>> Else
>>> Exit For
>>>
>>> End If
>>> Next i
>>> exright = NumStr1
>>> End Function
>>>
>>>
>>>
>>>
>>> On Thu, May 6, 2010 at 6:15 PM, anand shivappa <anand.shiva...@gmail.com
>>> > wrote:
>>>
>>>> Please help out. I got struct here.
>>>>
>>>>
>>>>
>>>> On Thu, May 6, 2010 at 5:45 PM, anand shivappa <
>>>> anand.shiva...@gmail.com> wrote:
>>>>
>>>>> Hi Everyone,
>>>>>
>>>>> I need to extract a rightmost word in a line through excel functions.
>>>>>
>>>>> Like USA Street is having no 10. I need to extract the last word like
>>>>> 10.
>>>>>
>>>>> Please help me out.
>>>>>
>>>>>
>>>>> Thanks and Regards,
>>>>> Anand S
>>>>>
>>>>>
>>>>> --
>>>>> When everything fails Patience will win
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> When everything fails Patience will win
>>>>
>>>> --
>>>>
>>>> ----------------------------------------------------------------------------------
>>>> Some important links for excel users:
>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>> http://twitter.com/exceldailytip
>>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> HELP US GROW !!
>>>>
>>>> We reach over 6,800 subscribers worldwide and receive many nice notes
>>>> about the learning and support from the group.Let friends and co-workers
>>>> know they can subscribe to group at
>>>> http://groups.google.com/group/excel-macros/subscribe
>>>>
>>>
>>> --
>>>
>>> ----------------------------------------------------------------------------------
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 6,800 subscribers worldwide and receive many nice notes
>>> about the learning and support from the group.Let friends and co-workers
>>> know they can subscribe to group at
>>> http://groups.google.com/group/excel-macros/subscribe
>>>
>>
>>
>>
>> --
>> P.VIJAY KUMAR
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>
>
> --
> One Team One Dream One Goal
>
> Warm Regards,
> Vikas Chauhan
> E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
> 9911868518,
> "We can't Spell S_ccess without U"
>
> Life is Very beautiful !!!
> ¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!
> `•.¸.•´.
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
--
When everything fails Patience will win
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
