Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combining words and nums. | Excel Worksheet Functions | |||
Combining information in sets of columns | Excel Discussion (Misc queries) | |||
Can excel underline misspelled words like Word? | Excel Discussion (Misc queries) | |||
triadic combinations of words | Excel Worksheet Functions | |||
Spell Checking - Special Words Not Picked Up by Excel | Excel Discussion (Misc queries) |