Autocorrecting an existing document

[EGP2018]

Hi,

I have a task where I copy/paste text from various sources (that cannot be changed) into a single workbook that I then use to upload to Access.

I've set up some autocorrects to changed the text into the format I want, but it's a long process clicking on every cell in turn.

Does anyone know if there's a way to run the autocorrect for the whole sheet or workbook?


Any help is appreciated.

 

[Dryver14]

if the thing you are correcting is similar throughout then you could try find and replace on the home tab.

 

[EGP2018]

Thanks - this is the way I'm currently doing it, but there's so many variables that I'm hoping to do it as automated and simply as possible.

if the thing you are correcting is similar throughout then you could try find and replace on the home tab.

 

[Dryver14]

without know what needs changing it is hard, changes could be done with VBA but if they are entirely random it won't help matters,

can you post a portion of whats coming in and what needs changing?

 

[hiker95]

EGP2018,

Welcome to the MrExcel forum.

It would help if we could see your actual raw data workbook/worksheets, and, what the results (manually formatted by you) should look like.

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com

 

[EGP2018]

Thanks,

It's difficult to post the workbooks as there are various sources.

An example though is as follows.

Line on Workbook A states 'BENCHMARKING AND COMMISSIONING PROCESS'. For my own benefit I change this to '33 - Benchmark Procedure'.

I've set up autocorrect so that I can click on each cell and press Return so it changes. It's possible though to have over 1000 lines and I'd ideally like a quicker way.

The Copy/Paste root works, I just didn't know if you can autocorrect on existing cells.

EGP2018,

Welcome to the MrExcel forum.

It would help if we could see your actual raw data workbook/worksheets, and, what the results (manually formatted by you) should look like.

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com

 

[hiker95]

It's difficult to post the workbooks as there are various sources.

EGP2018,

Then, let's start with the first one.