Convert to Column Formula = Specific Word

jelfner

Hello,

I want to make a column automatically populate a text word (i.e. CMHA) using Covert to Column Formula. I have done this in the past with a number but cannot remember and keep getting an error. I would appreciate your help!

KPH

I'm not sure I understand. Does this work:

Enter this formula in the column you want the text to appear in:

="CMHA"

Right click on the cell and choose "Convert to Column Formula"

KPH

I'm not sure I understand. Does this work:

Enter this formula in the column you want the text to appear in:

="CMHA"

Right click on the cell and choose "Convert to Column Formula"

jelfner

Thank you, that worked great!

KPH

Glad I could help!