#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combining words and nums. Eddie Excel Worksheet Functions 2 August 4th 06 03:54 PM
Combining information in sets of columns Ken Excel Discussion (Misc queries) 1 July 29th 06 08:10 AM
Can excel underline misspelled words like Word? Dave Excel Discussion (Misc queries) 1 April 5th 06 09:39 PM
triadic combinations of words jayock02 Excel Worksheet Functions 1 June 19th 05 02:10 AM
Spell Checking - Special Words Not Picked Up by Excel Hans Emilio Excel Discussion (Misc queries) 4 May 25th 05 02:25 PM


All times are GMT +1. The time now is 10:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"