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
