Creating/Shifting and Copy/Pasting Text Macro

Hello dear excel forum and excel forum users!

I need help with an excel VBA macro which I really want to create. The macro which I want to create should do following:

1. Checks cells with more than 69 characters in it (I'm currently using "Conditional Formatting" option with this formula - "=Len(a1)>69" and I'm filling the cells in yellow color if the condition is TRUE.)

2. After macro checks cells with more than 69 characters in them, it automatically inserts a new cell to the right (Right click>Insert>Shift cells to the right) and copies half text of the cell which was "full" (full in a sense that it had more than 69 characters in it) and pastes it into that newly created/shifted cell to the right.

I'd also like to mention I'm using this for the entire workbook, not just for selected cells inside the workbook.

That's basically it.
A copy/paste macro while creating/shifting cells to the right!

Thanks in advance to everyone who is willing to help!

Best regards.

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thanks a lot for the suggestion of uploading a sample workbook.

I uploaded one with the problem and a solution which I need written in it.

Thank you in advance for your help.

Best regards.