Combining Words

L

Lanza52

I'm looking for a way to combine two words.

A1 is a drop down menu with different words in it that serve as
prefix.

I'm looking for a way to make it so it shows =A1(suffix)

Example: A1 has a drop down list that includes the words: First
Second, Third and Fourth

I need to show the word "FirstInfo" in A4. Info being the suffix tha
needs to be added.

I tried just simply =A1Info but that didn't work.

Any help would be appreciated, thanks
 
Top