funtion please

  • Thread starter Thread starter JG
  • Start date Start date
J

JG

little help, thanks


I have a column with street addresses, the street numbers are
separated by one space from the street name.
I would like to cut the numbers (1 to maybe a high of 1900) and paste
the street numbers to an adjoining column.

I'll have to start reading Excel books. any recommendations. thanks
again
 
=LEFT(A2,FIND(" ",a2)-1)

and copy down

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

function please 8
Word Create a Phone Book using MailMerge in word 2007 0
In search of a new Obelisk 6
Excel Concatenate addresses in Excel but avoiding blanks, and line breaks 6
Convert mailing list from columns to rows 1
Moving part of a cell to another cell 2
Trimming numbers from street addresses 3
How do I replace just a few characters? 3

Back
Top