HELP

M

Mike

I have addresses in going down a column, wiht the street
number and name (ie. 68 E Main St.). Is there a function
that would pull out just the text into another cell? I
want to lose the house number, but not all addresses will
have the same number of digits in the house number, so I
didn't see how I could use LEFT, MID, or RIGHT. Any ideas?
 
N

Norman Harker

Hi Mike!

Try:

=MID(A1,FIND(" ",A1)+1,255)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
B

Bob Phillips

Mike,

For simple numbers try

=RIGHT(A1,LEN(A1)-FIND(" ",A1))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
T

Tiffany

Here's my suggestion:
Save the file (or column) as Tab Delimitted. Then with
Excel, Open file (text file) and import it as "Delimitted"
using Space. That will separate out the number from the
street name.
In order to combine multiple words in the street name, use
CONCATENATE Ex: =CONCATENATE(A1 & " " & A2)
 
Top