Find and replace multiple values in 43K row sheet

[kimt10]

Hello Excel Gurus, I'm seeking what I hope will be easy-to-follow advice for an average user!

I have a sheet with 43000+ rows; I have to convert a column of information by matching the first few characters and replacing it with a full unit name. How can I do this with a formula that I can easily cut and paste through 43K rows? Or is there another way to do this?

Here's a sample of the character/name legend (there are 15 or so more).

Thanks so much in advance.

[TABLE="width: 519"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Unit - First three digits[/TD]
[TD]Unit Name[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Business[/TD]
[/TR]
[TR]
[TD]FM[/TD]
[TD]Fair Market[/TD]
[/TR]
[TR]
[TD]FVG[/TD]
[TD]Fair Average[/TD]
[/TR]
[TR]
[TD]FP…A, G, P[/TD]
[TD]Fair Promo[/TD]
[/TR]
[TR]
[TD]FR[/TD]
[TD]French Product[/TD]
[/TR]
</tbody>[/TABLE]

 

[Logit]

.
Search all sheets (entire sheet):

https://www.thespreadsheetguru.com/the-code-vault/2014/4/14/find-and-replace-all


Search all sheets, Col A only:

https://stackoverflow.com/questions/17684155/excel-vba-find-and-replace