Amount | |
<tbody> </tbody> | |
<tbody> </tbody> | |
<tbody> </tbody> | |
¥128.00 | |
$129.00 | |
<tbody> </tbody> | |
$131.00 |
Anybody please.
Function GetCurrency(Rng As Range) As String
If IsNumeric(Left(Rng.Text, 1)) Then
GetCurrency = ""
Else
GetCurrency = Left(Rng.Text, 1)
End If
End Function