[Eliminating] First part of [text in a] cell

[manceI]

Is there an excel formula that will allow me to eliminate part of the text in a cell?

For example if cell A1 text says "FOUNTAIN VALLEY, CA*is 35 miles away" can I have the text B1 say "FOUNTAIN VALLEY, CA"

Thanks

[6StringJazzer]

Yes, but to provide a general formula we need to know the criteria that you are using to determine what text to eliminate. Is it everything after the "*"? Everything that is not a capital letter? Everything after a two-letter abbreviation for a state?

[manceI]

Thanks for the reply. Yes it will be everything after the 2 letter abbreviation for a state

[FlameRetired]

Perhaps

=LEFT(A1,FIND(",",A1)+3)