Formula to delete part of another cell value

[ArnolddG]

Hi,

In one cell, I have this value: "HJK1A_58.PM01"

I want to delete the '.PM01' part of the value from the period to the right.
The value behind the period can also be longer, so I need to delete all tokens after (and including) the period.
How would I do this?

Thanks for helping me out here...

[Ace_XL]

Try this..

Ctrl + H

Find: .*
Replace: Leave as blank
Ok

[akhileshgs]

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

From This

[ArnolddG]

Thanks you both for your help.
I am going for akhileshgs's code...
Works perfectly ! Issue solved...
Thanks again.

[akhileshgs]

Glad that we could help you.

Please close the thread. It will be the last option in the thread tools option in the ribbon

[ArnolddG]

Adding to my ealier question:
Can the same be done with multiple (but a fixed amount of) periods?
I would like to get a tag name without the tokens from the last period on:

A tag can be like:

"ABC.DEF.GHI.PM01"
"ABC.PJ.GHI.P05"
"ABC.PJ.TK.02"

I would like to get as a result:
"ABC.DEF.GHI"
"ABC.PJ.GHI"
"ABC.PJ.TK"

Thanks again for helping me out.
Arnold

[Glenn Kennedy]

More complicated, but do-able. With your data in column A, this should do the trick, copied down...

Please Login or Register  to view this content.

It counts the number of instances of periods and substitutes the last instance with an "|" and then selects everything t the left of the "|".

[ArnolddG]

Works perfectly Glenn !

Still wondering how you would figure these things out though...

Thanks again.
Arnold

[Glenn Kennedy]

I'm an Excel amateur. The way that true experts can see round a problem and come up with an elegant solution is amazing. I only knew this one, 'cos I'd been helped by someone else, months ago, to do almost the same thing.

Enjoy!