Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding two text cells together
I'm using Office 2000. Is there a way to combine two text cells together?
ex. A1 text "micro", A2 text "soft", A3 = "microsoft" Thank you for your time. |
#2
|
|||
|
|||
Hi Audrey
In A3 this formula =A1&A2 -- Regards Ron de Bruin http://www.rondebruin.nl "Audrey" wrote in message ... I'm using Office 2000. Is there a way to combine two text cells together? ex. A1 text "micro", A2 text "soft", A3 = "microsoft" Thank you for your time. |
#3
|
|||
|
|||
Hi!
No need to post the same question 4 minutes later! Patience! See your earlier post. Biff -----Original Message----- I'm using Office 2000. Is there a way to combine two text cells together? ex. A1 text "micro", A2 text "soft", A3 = "microsoft" Thank you for your time. . |
#4
|
|||
|
|||
use the =concatenate function. Looks like this. =concatenate(a1,a2)
"Audrey" wrote: I'm using Office 2000. Is there a way to combine two text cells together? ex. A1 text "micro", A2 text "soft", A3 = "microsoft" Thank you for your time. |
#5
|
|||
|
|||
When I posted the first one, error on the screen stated that
my posting did not take and to resubmit it. That's what I did. "Biff" wrote: Hi! No need to post the same question 4 minutes later! Patience! See your earlier post. Biff -----Original Message----- I'm using Office 2000. Is there a way to combine two text cells together? ex. A1 text "micro", A2 text "soft", A3 = "microsoft" Thank you for your time. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help adding text values | Excel Worksheet Functions | |||
how do i add the same text after current text in multiple cells | Excel Discussion (Misc queries) | |||
Adding cells, using text as number | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Adding cells with numbers and text | Excel Worksheet Functions |