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

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

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

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
---
"Mr. Most" wrote:
.. one column there is street number and space and then the street name
I want to move the street number to separate column

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

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

"Mr. Most" wrote:

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

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

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
---