Excel: Cleaning data

I have data which appears as: 447596125369 44 appears in all cells I need to replace 44 with 0 and add a space to result in 07596 125369 I have 500,000 records so find / replace is not an option Can anyone help?

This question generated 20 answers. To proceed to the answers, click here.

This thread is current as of May 15, 2014.

For more resources for Microsoft Excel