How I can separate text and number in one column from each others

[Mr. Most]

would you please answer me. I one colume there is street number and space and
than the street name. I want to move the street number to separate column

 

[Max]

Assuming there's only a single space in your data
Easiest way to split that 1 col into 2 cols
is via Data > Text to Columns, Delimited > Space
(just ensure that there's an empty col to the right)

Try it on a spare copy, its fast n easy

Experiment also with Data > Text to Columns, Fixed Width option, where you
can decide where exactly to split it, and to remove unwanted any split lines
inserted by Excel which may not be required

Give a thumbs up here if it works well for you, click the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik

 

[FSt1]

hi
an example of your address would have been nice. plus the column that it is
in but
assuming that the address in in collumn A and look something like this...
123 Main St.
for the street number, try this in column B.....
=LEFT(A3,FIND(" ",A3,1)-1)
for the street name, try this in column C....
=RIGHT(A3,LEN(A3)-FIND(" ",A3,1))

Regards
FSt1

 

[Max]

Typo in this part, it should read as:

.. and to remove any unwanted split lines
inserted by Excel which may not be required

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---