How to combine cols of text in Excel 4.0?

Thread View: comp.apps.spreadsheets

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Robert G. Carpenter Mon, 12 Oct 1992 18:53

#189

Author: Robert G. Carpenter
Date: Mon, 12 Oct 1992 18:53

21 lines
641 bytes

I can't figure out how to combine two columns of text
in Excel 4.0. For example, if you have these two columns
of text:

  aaa  123
  bbb  123
  ccc  123
  ddd  123

and want to combine them to end up with:

 aaa123
 bbb123
 ccc123
 ddd123

how would you do it?

Thanks in advance.

BobC.

Re: How to combine cols of text in Excel 4.0?

#194

Author: *Steve White
Date: Tue, 13 Oct 1992 00:30

46 lines
1695 bytes

In <3840@bcstec.ca.boeing.com> rgc3679@bcstec.ca.boeing.com writes:

> I can't figure out how to combine two columns of text
> in Excel 4.0. For example, if you have these two columns
> of text:
> 
>   aaa  123
>   bbb  123
>   ccc  123
>   ddd  123
> 
> and want to combine them to end up with:
> 
>  aaa123
>  bbb123
>  ccc123
>  ddd123
> 
> how would you do it?
> 
> Thanks in advance.
> 
> BobC.


Assuming that the letters are in A1 to A4 and the numbers
are in B1 to B4, the following works in Excel 3.0 so I guess
it also will do the trick in Excel 4.0:

=A1&B1
=A2&B2
=A3&B3
=A4&B4

in C1 to C4 returns the following:

aaa123
bbb123
ccc123
ddd123

Steve
--------------------------------------------------------------------------
    << The above are nothing more than my personal opinions >>
stephen r. white -- whitesr@appstate.bitnet -- whitesr@conrad.appstate.edu
--------------------------------------------------------------------------

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads