![]() |
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. |
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. |
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. . |
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. |
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. . |
All times are GMT +1. The time now is 01:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com