can the text of two cells be combined with merge

**jamie.c** · 01-20-2010, 07:25 AM

Hello everyone,

I dont think this is possible but if someone can tell me for sure it would be much appreciated!

Ive got numbers in cell A eg. 10062

I have then got a dash & a letter in cell B eg. -H

Is there anyway that is not manual to join the two so they become 10062-H in a singel cell, with a view to apply it to hundeds of numbers?

Thanks

Jamie.c

**romperstomper** · 01-20-2010, 07:32 AM

What do you mean by 'not manual'?
If the data is all in two columns, then a simple formula should suffice.

**jamie.c** · 01-20-2010, 07:45 AM

Thanks for your speedy reply,

By manual I mean individually going into each cell & adding the text hundreds of times,
would it be possible for you to help me out with the code as i have got a very basic knowledge of excel.

Any help would be much appreciated.

Kind regards

Jamie.c

**romperstomper** · 01-20-2010, 07:48 AM

Is it OK to use a formula in another column or do you actually want to replace one of the existing columns with the combined data? Also, I am assuming that the data is all together in two adjacent columns, is this the case?

**jamie.c** · 01-20-2010, 08:08 AM

It would be excellent if you could replace cell whats in cell A & B with the comblined text in cell A and then I can delete the contents of column B.
The data is adjacent.

Many thanks

Jamie.c

**romperstomper** · 01-20-2010, 08:17 AM

Here's some code. Note:
1. You need to select your data first (both columns)
2. It's air code, so untested!

Please Login or Register  to view this content.

**jamie.c** · 01-20-2010, 08:28 AM

Thank you very much Romperstomper!

I will give it a whirl & let you know how I got on

Thanks again

Jamie.c

**jamie.c** · 01-20-2010, 09:58 AM

Ive added the code you kindly sent me into a worksheet, By right clicking on the sheet and clicking view code then pasting into the page. Is that correct? what trigger the code to work?

Many thanks

Jamie.c

**darkyam** · 01-20-2010, 09:59 AM

You could also do =A1&B1 in C1, copy down as needed, copy C and paste special as values over itself, and delete columns A and B.

**romperstomper** · 01-20-2010, 10:23 AM

Originally Posted by jamie.c

Ive added the code you kindly sent me into a worksheet, By right clicking on the sheet and clicking view code then pasting into the page. Is that correct? what trigger the code to work?

Not quite. You need to insert a new module (after the View Code step, choose Insert-Module from the menu) and paste the code in there. Then press Alt+f11 to go back to the main Excel window, select the data, then press Alt+f8 to bring up the macros dialog and run the CombineData macro.