|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
How do I strip just numbers from an alphanumeric cell?
check out
http://www.ozgrid.com/VBA/ExtractNum.htm
"Benjamin" wrote:
I need to strip just the numbers after the last -
RV01-HYC0246-43-T-892A i.e. 892
RV01-HYC0246-43-H-892 i.e. 892
I know how to use the Right(and find("")) commands.
Any help on just numeric character and not alphas?
|