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.

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.

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

"Crosscatch" wrote:

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.