LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default Extracting numbers from a single sell

Hi, there!

The situation goes like that : I have a messy cell that contains both
adresses and a couple of phone numbers per client. The problem is that
i need only the phone numbers. Is there a way that i can exctract each
one of them in a different cell - i mean if this client has 3 numbers
specified in the messy cell, they should be distributed in 3 separated
cells. Also as you can guess the adresses includes numbers, that are
not needed, and basically this can be worked around ( i guess ) by
specifying that we need numbers with more that 5 digits.

P.S. I`m not very advanced users, so I`ll apreciate detailed ( as for
dummies ) explanation.

Thanks in Advance,

Georgi
 
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
Extracting numbers and letters in a single cell to separate cells lawandgrace Excel Discussion (Misc queries) 1 August 14th 09 04:45 PM
Extracting single piece of data Louis Excel Discussion (Misc queries) 7 February 9th 06 12:28 AM
Extracting single piece of data Ron Coderre Excel Discussion (Misc queries) 0 February 8th 06 07:51 PM
can you count the number of letters (inc spaces) in a single sell greenstone New Users to Excel 2 August 3rd 05 11:06 AM
Extracting data from a single cell rockspeed Excel Programming 1 November 28th 03 03:16 PM


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

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

About Us

"It's about Microsoft Excel"