On Sep 1, 10:21*am, Eduardo wrote:
Opps there is a comma *missing

=LEFT(A1,LEN(A1-5)



"Eduardo" wrote:
hi,

=LEFT(A1LEN(A1-5)

if this helps please click yes thanks

"MaryJ" wrote:

Hi, Column C has a bunch of addresses that have no spaces between the
number and street. *(27smith lane instead of 27 smith lane). *Is there
a way for me to quickly seperate the number and street name from the
preceding number in each cell of column c? *There are 1075 cells in
column C. *Thanks!- Hide quoted text -

- Show quoted text -

Ok, I'm still kind of confused... there are different lengths of
numbers. Any chance I could get a little more help?