Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Characters in cell | Excel Discussion (Misc queries) | |||
Transfer specific characters from cell to another cell. | New Users to Excel | |||
masking credit card info when worksheet is printed | Excel Discussion (Misc queries) | |||
Display masking | Excel Discussion (Misc queries) | |||
Masking numbers | Excel Worksheet Functions |