Excel Macros Display Text Based On Condition

Newbie to Excel.

Objective:

• Search entire column identifying the first letter of text in each cell based on set variables
• Based on the condition that is met, display the results in a new column with corresponding results within the cell row.

Example: A = Astro , E = Elroy, G = George, R = Rosie, C = Cogswell, S = Spacely Column K Column Z Grape Raspberry Rosie Cream Sauce Apple

I know doing a Left function will allow me to identify the first letter of each word. However, I want to scan the entire Column K without having to do individual cells. Also, I want the matching result if condition is met to display in Column Z.

The goal is to create macros that can be used for any workbook.

--Thanks