View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dnardi dnardi is offline
external usenet poster
 
Posts: 1
Default Masking out characters in a cell

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