Masking out characters in a cell
Are there always 3 digits in front? If so (assuming A1 is the source
cell)...
=LEFT(A1,3)
If not a constant number of digits, are the digits always in front? If so,
this is one way...
=LEFT(A1,SUMPRODUCT(--ISNUMBER(--MID(A1,ROW($1:$999),1))))
Something else? Tell us what.
Rick
"dnardi" wrote in message
...
How should one mask out unwanted characters in a range of cells or
extranct
the wanted character set within a cell to another cell?
Source cell: 123ABC
Desired data to be extracted: numbers only
Which function should be used to either mask out the unwanted letters and
leave the numbers or extract to another (set of) cells by filtering by
position within the source cell or by the character type desired?
--
Sincerely,
Billiamm
|