![]() |
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