Find Last Character Position

[kashif.special2005]

Hi,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
How can I find last character position
<o> </o>
Kj34552 : last character position is 2
Tiwu45829 : last character position is 4
<o> </o>
I am using this array formula is giving me first character how can I find last character position
<o> </o>
MID(A5,ROW(INDIRECT("1:"&LEN(A5))),1)
<o> </o>
Please help
<o> </o>
Thanks,
Kashif.<o></o>

 

[Robert Mika]

Try this:
Array formula confirm CTRL+SHIFT+ENTER:
=LEN(SUBSTITUTE(A1,MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$9),1)),0),COUNT(1*MID(A1,ROW($1:$9),1))),""))

 

[Aladin Akyurek]

Hi,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
How can I find last character position
<o></o>
Kj34552 : last character position is 2
Tiwu45829 : last character position is 4
<o></o>
I am using this array formula is giving me first character how can I find last character position
<o></o>
MID(A5,ROW(INDIRECT("1:"&LEN(A5))),1)
<o></o>
Please help
<o></o>
Thanks,
Kashif.<o></o>

Try...

=MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789"))-1

assuming that the digits are always at the end of the string of interest.

 

[CWatts]

You can try the following User Defined Function for a VBA solution:

If your string is in A1, you can use =LastChar(A1) in your worksheet.

Function LastChar(str As String) As Integer
Dim FirstNumber As String
With CreateObject("VBScript.RegExp")
     .Pattern = "\d"
     FirstNumber = .Execute(str)(0)
End With
LastChar = Application.WorksheetFunction.Find(FirstNumber, str, 1) - 1
End Function

 

[kashif.special2005]

Thank you so much friends

 

[Aladin Akyurek]

Thank you so much friends

You are welcome. Thanks for providing us feedback.