Extracting partial red strings and replacing them with dots

Working on a large worksheet with 80k or rows and 8 columns A-H, I need to:

1. Extract the red text from each cell in Column F,
2. place it in the same row at column I, and
3. fill its position with ten dots.

I have attached an example with two worksheets, where Sheet1 has the raw data before any processing, and Sheet2 with data in its final shape. For sure, there's no need to retain the red colour in ColI as it is in the example, I put it in red just for illustration.

Please note that the real red data in ColF vary dramatically in size, so "a special method" (?) is needed to quicken both extraction and dots replacement process.

More than grateful for any precious assitance with this question.

Many thanks in advance.

T.

Thanks Bakerman2 for your input, which I really appreciate. In fact, I tried Sktneer's script and it worked great with the following comments:

@Sktneer, really thank you very much for your prompt solution. I tried it on 155 records (rows) of my real data and found:
1. it did extract the red portions and placed them in ColI,
2. it did replace the red portions in their original F column positions with dots, but actually NOT 10 DOTS, BUT LOTS AND LOTS OF DOTS, which is not the desired result,
3. it took nearly 3 minutes to finish 155 rows.

So, is it possible to modify the script to accommodate for a 10-dot replacement only, and to make the script run a "bit faster" as I requested in my original question?
Once again, thank you very much Sktneer for such masterpiece code ..

Thank you very much Sktneer for your prompt and valuable response.
I did apply the change, and it worked perfectly.
This question is solved by you Sktneer through your genius code.
Please accept my deep respect and gratitude.

All the best ..

T.

Originally Posted by rorya

Were you very bored?

I'm very sorry rorya for this belated reply, I just noticed it as I'm back to work.
I really don't know what to say, thank you very much indeed for such masterpiece code. It did run far much faster saving a lot of time.
.. with full respect and gratitude.

All the best.

T.