I'm looking for a way to combine two words.
A1 is a drop down menu with different words in it that serve as a
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 that
needs to be added.
I tried just simply =A1Info but that didn't work.
Any help would be appreciated, thanks.
--
Lanza52
------------------------------------------------------------------------
Lanza52's Profile:
http://www.excelforum.com/member.php...o&userid=36316
View this thread:
http://www.excelforum.com/showthread...hreadid=573481