left trim
Copy and paste the formula ro any cell except A1.
Will return 1 Airport Boulevard into that cell as long as A1 contains
1 Airport Boulevard, Gentry, AR 72734
Gord Dibben MS Excel MVP
On Sat, 28 Apr 2007 05:20:00 -0700, Finger Tips
wrote:
Where do I put this and use this?
"Teethless mama" wrote:
=LEFT(A1,FIND(",",A1)-1)
"Finger Tips" wrote:
Hello, I need a query that will left trim everything after the first comma in
a string.
Example
1 Airport Boulevard, Gentry, AR 72734
I need just the street address to remain.
Also some of the cells in the column are blank, some cells have only the
city and state. Also need to know hoe the run it and from where. Thanks
|