ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Combining Words (https://www.excelbanter.com/excel-worksheet-functions/106044-combining-words.html)

Lanza52

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


Otto Moehrbach

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





All times are GMT +1. The time now is 02:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com