hi
sorry about that command
we can use right command for that
regards
vikas
On Wed, May 12, 2010 at 9:19 AM, anand shivappa
anand.shiva...@gmail.com wrote:
Can you send me the code for RTRIM it.
Because I cannot find in Excel function list.
Thanks and Regards,
Anand S
On Tue, May 11,
Can you send me the code for RTRIM it.
Because I cannot find in Excel function list.
Thanks and Regards,
Anand S
On Tue, May 11, 2010 at 6:10 PM, vikas gupta vikas.63...@gmail.com wrote:
HI ANAND
YOU CAN USE RTRIM COMMAND
REGARDS
VIKAS GUPTA
9311334683
On Thu, May 6, 2010 at 6:15
HI ANAND
YOU CAN USE RTRIM COMMAND
REGARDS
VIKAS GUPTA
9311334683
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
hi how to use the command pls ex plane
On Tue, May 11, 2010 at 6:10 PM, vikas gupta vikas.63...@gmail.com wrote:
HI ANAND
YOU CAN USE RTRIM COMMAND
REGARDS
VIKAS GUPTA
9311334683
On Thu, May 6, 2010 at 6:15 PM, anand shivappa anand.shiva...@gmail.com
wrote:
Please help out. I got
Hi Anand,
You are right, that Asish solution is perfect,
but if you don't want to use VBA you can use this one.
=RIGHT(A1,LEN(A1)-FIND(~,SUBSTITUTE(A1,
,~,LEN(A1)-LEN(SUBSTITUTE(A1, ,)
Don't see its size, because it is smallest possible using formula.
And I assume that your text don't have
Thanks Ashish. You have cleared my burden.
Thanks a ton.
Thanks and Regards,
Anand S
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))
hi anand how are you
AB
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
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
Please help out. I got struct here.
On Thu, May 6, 2010 at 5:45 PM, anand shivappa anand.shiva...@gmail.comwrote:
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
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
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 ContainsTIGER999 .Use the function = RIGHT(B2,3) to get
the required 999 as the answer.
On Thu, May 6, 2010 at
11 matches
Mail list logo