ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Adding two text cells together (https://www.excelbanter.com/excel-discussion-misc-queries/14853-adding-two-text-cells-together.html)

Audrey

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.


Ron de Bruin

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.




Biff

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.

.


Jim

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.


Audrey

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