I am not familiar with Exel at all, but I just need to fix some things.

I'm new to Excel, and everything I've tried to figure out on my own has resulted in "INVALID" or not doing anything at all.
Basically, I'm trying to sort this...

absence – abcense, absance[3][10]
acceptable – acceptible[4]
accidentally/accidently – accidentaly[4]
accommodate – accomodate, acommodate[3][4]
achieve – acheive[3]
acknowledge – acknowlege, aknowledge[3]
acquaintance – acquaintence, aquaintance[3]
acquire – aquire, adquire[4]

...into the following Excel file in the fastest way possible. Obviously I have the rest of A and then B-Z as well. I am filling "::" in columns A and C, the left word in column B, and the right word (which is actually right!) in column D.

Im sorry, but I have no clue what you are trying to do here, nor what your expected outcome would look like

Could you walk us through, step by step if needed, to explain what you are doing?

Here's a PowerQuery solution.

The original data is in sheet 1 and the transformed data in sheet 2.

M Code:

Please Login or Register  to view this content.