This will remove the periods:

=SUBSTITUTE(A1,".","")

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Crosscatch" wrote in message
...
I need to clean the periods from the first column and the first 6
characters
of the new data. In otherwords, I need column B to come from column A.
PR.44.CC.106 PR44CC
I can use the Left function and I can use the REPLACE function but I need
to
use them in one formula (mega-formula?) if possible.

Many thanks for your help.