Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove Numbers from Alphanumeric String Dave Excel Discussion (Misc queries) 27 December 25th 16 02:33 AM
Extracting 7 digit number from alphanumeric string snowball Excel Discussion (Misc queries) 5 August 31st 09 11:51 AM
Extracting numbers from alphanumeric data Flu Excel Discussion (Misc queries) 4 September 12th 08 11:16 AM
Extracting numbers from alphanumeric strings Poonam Excel Worksheet Functions 5 April 5th 08 01:27 AM
extracting numbers from alphanumeric cells Mary Excel Worksheet Functions 6 February 22nd 07 12:04 PM


All times are GMT +1. The time now is 04:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"