U
u473
I have a column of data with inconsistent data entry format from which
I need to
extract the significant digits after the # sign.
I cannot simply use a Right function because the data I need to
extract is embedded in a text string..
FIND the # sign is only the beginning of the solution. But how do I go
from there ?
There is always a space between the last digit and the following
description text.
CO#002 Description text... Expected extraction : 2
CO# 005 xxxxxxxx... Expected extraction : 5
CO#0007 yyyyy... ... Expected extraction : 7
CO # 010 zzz.......... Expected extraction : 10
Help welcomed.
Celeste
I need to
extract the significant digits after the # sign.
I cannot simply use a Right function because the data I need to
extract is embedded in a text string..
FIND the # sign is only the beginning of the solution. But how do I go
from there ?
There is always a space between the last digit and the following
description text.
CO#002 Description text... Expected extraction : 2
CO# 005 xxxxxxxx... Expected extraction : 5
CO#0007 yyyyy... ... Expected extraction : 7
CO # 010 zzz.......... Expected extraction : 10
Help welcomed.
Celeste