ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Extracting numbers from alphanumeric string (https://www.excelbanter.com/excel-discussion-misc-queries/252973-extracting-numbers-alphanumeric-string.html)

Ales

Extracting numbers from alphanumeric string
 
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


All times are GMT +1. The time now is 06:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com