I've searched for the answer here and have come to the conclusion that I do not know the correct terminology to aptly search my question. Uploaded here is a sheet that shows our product line, UPC codes, description, etc. In row 2, 3, 4 I've edited to the correct format that I need the rest of the sheet to follow. The "Style" column should look like "D5-0007 or D5-0018W or D5-8321" etc. The "Color" column can be any number of digits or letters, though typically it will look like "04 or 85 or 8593 or 93sy or 53bdm" etc. Is there a macro that can do this tedious work instead of individually editing all 10k plus rows?