| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing characters from a cell (keeping only the numbers)
Hi..,
Is there a formula to enable me to copy just the numbers of a cell which also contains letters/characters (example Cell A1: FT/@12345 ) All I want to do is remove all the non number characters (leaving me with 12345 in the above example)..? Im unable to use the left, mid and right formulas (well be longwinded) as there is no specific number of characters before or after the actual numbers (which are always together/not split up)€¦? Any thoughts ..? Many thanks Monk |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| numbers being entered show in formula bar but not in cell? | Excel Discussion (Misc queries) | |||
| Averaging Numbers when 2 numbers in one cell | Excel Worksheet Functions | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
