Mid function query

[VBABEGINER]

Pls Note: The following query answer i got from one of our MrExcel Member, but this is some applicable to limited no. of result, hence query asking again.

The solution I got that is-

=MID(F12,1,FIND(".",F12)-1)&MID(F12,FIND(" ",F12),FIND(".",F12,FIND(" ",F12))-FIND(" ",F12))

My query was, i have data like,
Tag No.
P01.SG-17 P01B.SG-18
P01.SG-17 P01A.SG-25
P05.SG-21 P05A.SG-22
P02.SG-11
P02.SG-12
P07.SG-12 P07A.SG-15 P07B.SG-16

O/p should be -
P01 P01B
P01 P01A
P05 P05A
P02
P02
P07 P07A P07B

The reason i red marked, the formula is fixed. That made for 2 naming convention only. Not Single ("P02.SG-11") or for three content.
That is, if set this much only-

=MID(F12,1,FIND(".",F12)-1)&MID(F12,FIND(" ",F12))

then this will applicable to only single naming convetions.

I dont want this.
tag no. can be any length of content. Only SG tag dont want to display.
Tha is from 1st "." to space and like way.

Can any one there to SOLVE problem?

I am also trying some R&D, by using SUBSTITUTE function.

 

[VBABEGINER]

Here, Right click - View code select

Backend page open.

I was paste that code into that.

Go to excel sheet.

A1 having that data.

B1 =StripTag(A1) like wise so on.

Save.

but after report come. nothing happen.

is that i need to put under event like "Before Save" or any.

 

[niceguy_jay]

don't right click on any button...this is a custom function....

Press Alt+F11
Then insert a new module and paste the code mentioned...check my previous post on page 1

 

[VBABEGINER]

Heee hhhhhheeeeeeeeee guys.

I got I got its amazing yaar.

Thank You very much.

God Bless You, All. Your all dreams comes True.