| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Adding Two Text Fields together
I'm using Office 2000. Is there a way to combined two "Text" cells into one
cell? Ex. A1 text is "micro", A2 text is "soft, A3 = "microsoft". Thank you for your time. |
|
#2
|
|||
|
|||
|
Hi!
=A1&A2 OR =CONCATENATE(A1,A2) Biff -----Original Message----- I'm using Office 2000. Is there a way to combined two "Text" cells into one cell? Ex. A1 text is "micro", A2 text is "soft, A3 = "microsoft". Thank you for your time. . |
|
#3
|
|||
|
|||
|
Audrey
In A3 enter =A1 & A2 When happy, you can copy A3 and EditPaste SpecialValuesOKEsc. Clear Contents of A1 and A2 if you desire. Gord Dibben Excel MVP On Thu, 24 Feb 2005 11:51:04 -0800, Audrey wrote: I'm using Office 2000. Is there a way to combined two "Text" cells into one cell? Ex. A1 text is "micro", A2 text is "soft, A3 = "microsoft". Thank you for your time. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i have fields that are formatted for text that randomly convert t. | Excel Discussion (Misc queries) | |||
| Help adding text values | Excel Worksheet Functions | |||
| Adding Leading Zeros to Text | Excel Discussion (Misc queries) | |||
| using sumproduct in a range of text fields? | Excel Worksheet Functions | |||
| Adding a text label to a line. | Charts and Charting in Excel | |||
Linear Mode
