Find n replace

[VBABEGINER]

Hi,

i have stuck with final touch up.

Can any one tell me the idea about following?
In col A-

P07.SG-12 P012.SG19................cell a1
P05.SG-19 P011.SG09................cell a2
P111A.SG-012 P112.SG23...........cell a3

How i can find content of cell? actually im totally unware about this.
Im trying to find first .red marking above.
OR

.Replace What:=".SG- ", Replacement:=" ", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

but, this ".SG-12"
can we have any trick that find . and "SG-12" this content how can we search?

woooow....this makes confusing, more explaination.

can any one understand or help me how to guide you.

 

[RichardMGreen]

From the sample posted above, what do you want to see after you've made the changes?

 

[VBABEGINER]

Thank You for kind attention.

It should look like this -

P07 P012................cell a1
P05 P011................cell a2
P111A P112.............cell a3

 

[VBABEGINER]

Pls any one.
This is im on final stage.

 

[RichardMGreen]

You don't need a macro, you can use this formula:-
=MID(A1,1,FIND(".",A1)-1)&MID(A1,FIND(" ",A1),FIND(".",A1,FIND(" ",A1))-FIND(" ",A1))
and drag it down.
I've assumed all your codes are in column A.

 

[VBABEGINER]

Actually my all requirement in coding only.
this is what my seniours want.
any ways i try it first.

Thanx again, for kind reply.