Removing everything to the right of the first period.

[dlamberth]

I’m looking for a formula that will look at a string and remove everything to the right of the first period, including the period itself.

Here’s an example of the text I’m working with. I’d like to remove the “....26.00”
AIR FILTER....26.00

And make it look like this:
AIR FILTER

I thank you

[CheshireCat]

Try this:

Please Login or Register  to view this content.

[martindwilson]

you dont need formula just find .* replace with nothing
=LEFT(A2,SEARCH(".",A2)-1) doesnt work if there are 3 or more periods
you need to use
=LEFT(A15,SEARCH(".",A15)-2)
if you want to use
=LEFT(A2,SEARCH(".",A2)-1)
you need to delete ... from your autocorrect options
then again maybe if it was imported as text........something it will work fine anyway