Remove the part that beginning with ...

[YasserKhalil]

Hi everybody
I know that my questions are much
But I know also that you are able to solve any problem
for example
hhhhhh.gfdgfg..gfgfgfg...sdfsdf
I want to remove / get rid of the part after the three dots and the three dots too
the result should be : hhhhhh.gfdgfg..gfgfgfg

 

[Weaver]

first off, you need to find out where the "..." is in the string

You can do that using =FIND()

Then you need to chop off the leftmost part of the string up to this point

You can do that using =LEFT()

so you get

=LEFT(A1,FIND("...",A1)-1)

Where cell A1 contains your string

the -1 is to make sure you don't get the first of the three dots (...)

HTH

 

[YasserKhalil]

thank you very much
It's helpful