Function to find value in string
thank you for the help :)
"Niek Otten" wrote:
If you happen to use Excel2007 (or even 2010), then REV32 is not a valid
function name, because it is a cell address.
If you change the function name you'll see your function working as
expected.
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"John" wrote in message
...
Hi can someone help with this funtion
if the cell selected as the input for the function is 123'150
then I would expect this to return 150
Public Function rev32(Price As String)
'=RIGHT(J5,LEN(J5)-FIND("'",J5))
rev32 = Right(Price, Len(Price) - InStr(Price, "'"))
End Function
I get a REF error
|