Thread: Combining Words
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lanza52 Lanza52 is offline
external usenet poster
 
Posts: 1
Default Combining Words


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