I have an imported spreadsheet that I am incorporating into my online store.
It contains about 4500 records. I made a CSV copy to comply with the web
requirements. Now I want to change the contents of some cells.

Example:
Manufacturer part number may be 110-A. I need to change that to KN-110-A.

In other words, I need to add KN- to @4500 part numbers in a column. The
manufacturer part numbers do not always follow a specific format (numbers
only, no hyphens, letters etc.) I know there is a way to do this easily or
relatively easy, I searched the help files but came up empty. Any help?