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

=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

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

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

Worked great thanks. How do I run it for a group of cells. I have a column
that contains several thousand cells that I need to do this for.

"Gord Dibben" wrote:

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

Place the formula in the top cell of a column adjacent to the data column then
double-click on the fill handle of the cell.

i.e. data strings in column A

In B1 enter the formula then hover the mouse pointer over the bottom right
corner of B1. When you see a black cross, double-click on that. The formula
will be copied down.

When you get a few minutes(or hours) take a look at these sites for help on
working with Excel.

Some tutorial sites for basics of Excel........

http://www.usd.edu/trio/tut/excel/index.html

http://www.baycongroup.com/el0.htm

http://office.microsoft.com/en-us/tr...831141033.aspx


Gord

On Sat, 28 Apr 2007 13:06:01 -0700, Finger Tips
wrote:

Worked great thanks. How do I run it for a group of cells. I have a column
that contains several thousand cells that I need to do this for.

"Gord Dibben" wrote:

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