Hi there,

I have a series of text data in one column and a series of figures in
another column. I want to join them together to create one column (i.e.
GH in column A and 4589 in column B will produce GH4589)

I'm trying to think of ways of doing it but my knowledge is very
limited. I am however good at copying and pasting code......Can anyone
help?

Chris

wrote:
Hi there,

I have a series of text data in one column and a series of figures in
another column. I want to join them together to create one column (i.e.
GH in column A and 4589 in column B will produce GH4589)

I'm trying to think of ways of doing it but my knowledge is very
limited. I am however good at copying and pasting code......Can anyone
help?

Chris


Dear Chris,

Use the excels built in formula =concatenate(starting data,ending
data).

Regards
Thyagaraj

You can use the CONCATENATE function.

For example, if you have the letter A in cell A3, and you have the
number 1 in cell B3, you can use the following formula...

=CONCATENATE(A3,B3)

To give you the result of A1.

yes

=CONCATENATE(

works!

thanks very much


DAV135 wrote:
You can use the CONCATENATE function.

For example, if you have the letter A in cell A3, and you have the
number 1 in cell B3, you can use the following formula...

=CONCATENATE(A3,B3)

To give you the result of A1.

wrote:
Hi there,

I have a series of text data in one column and a series of figures in
another column. I want to join them together to create one column (i.e.
GH in column A and 4589 in column B will produce GH4589)

I'm trying to think of ways of doing it but my knowledge is very
limited. I am however good at copying and pasting code......Can anyone
help?

Chris

Hi Chris

Does it have to be code?

The formula

=A1&B1

will do the trick

Regards

Steve