Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I found this formula. How can it be mended to extract the numbers from alphanumeric data into a new column? The number also includes other characters e.g. "/" and "-" or a letter which would need to be included on the extraction and could be at the end or beginning of the string (basically street name and house number) e.g. 55 Grove Hill Rűpniecîbas iela 2789 Senatorska 18A Ul. Brzezińska 50/15 Many thanks Ales |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Remove Numbers from Alphanumeric String | Excel Discussion (Misc queries) | |||
Extracting 7 digit number from alphanumeric string | Excel Discussion (Misc queries) | |||
Extracting numbers from alphanumeric data | Excel Discussion (Misc queries) | |||
Extracting numbers from alphanumeric strings | Excel Worksheet Functions | |||
extracting numbers from alphanumeric cells | Excel Worksheet Functions |