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
Otto Moehrbach - 20 Aug 2006 02:36 GMT
=A1 & "Info"
Does that do what you want? HTH Otto
> I'm looking for a way to combine two words.
>
[quoted text clipped - 12 lines]
>
> Any help would be appreciated, thanks.