=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.