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

=A1 & "Info"
Does that do what you want? HTH Otto
"Lanza52" wrote in
message ...

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