Excel request

Reply #13

billybouy — Thu, 02 Aug 2012 16:37:28 GMT

Hi GASMETERGUY, here is a book in pdf. file you may find it helpful

https://www.box.com/s/097146470666c5ccf69d

,

billybouy...

Reply #12

GASMETERGUY — Thu, 02 Aug 2012 00:16:16 GMT

I tried this and it did what I wanted. Thanks.

And the reason I don't want to just put =A1 B1 was due to the fact I was unaware of this function. Now I have been ed-u-ma-cated.

Reply #11

SergeM — Wed, 01 Aug 2012 16:02:23 GMT

I have data in cell A1 and B1. A1 contains the number 11. B1 contains the number 21. What I would like to accomplish via VBA is put the numbers of these two cells in another cell such that the third cell would show 1121 .

Is there a method for doing something like this?

Yes, there is

Reply #10

mathhead — Wed, 01 Aug 2012 00:51:43 GMT

GasMeterGuy wrote (emphasis added): ``I have data in cell A1 and B1. A1 contains the number 11. B1 contains the number 21. What I would like to accomplish via VBA is put the numbers of these two cells in another cell such that the third cell would show 1121 . Is there a method for doing something like this?``

Sorry. I keyed off some other responses and overlooked the fact that you are looking for a VBA solution. If you want to modify another cell, presumably you are writing this in a sub(rout... [ More ]

Reply #9

phileight — Wed, 01 Aug 2012 00:28:39 GMT

Gasmeterguy

in vba try this code

a=cell(1,1)*100

b=cells(1,2)

cells(1,4)=a+b

p8

Reply #8

mathhead — Mon, 30 Jul 2012 22:00:35 GMT

GasMeterGuy wrote: ``I have data in cell A1 and B1. A1 contains the number 11. B1 contains the number 21. What I would like to accomplish via VBA is put the numbers of these two cells in another cell such that the third cell would show 1121 . Is there a method for doing something like this?``

GasMeterGuy wrote: ``After appending, I might be able to convert the text back to a number.``

The simplest way to accomplish that is:

=--(A1 B1)

The double-negative converts numeric text to a nu... [ More ]

Reply #7

SergeM — Mon, 30 Jul 2012 19:28:24 GMT

Why do you want to put 11 and 21 together?

Variation:

R\C A B C

1 1 2 0102

2 0 0 0000

3 11 21 1121

Reply #6

LottoBoner — Mon, 30 Jul 2012 18:18:37 GMT

Main Entry:1con cat e nate Pronunciation:k*n-*ka-t*-n*t, k*n- Function:adjective Etymology:Middle English, from Late Latin concatenatus, past participle of concatenare to link together, from Latin com- + catena chain Date:15th century

: linked together

Reply #5

winsumloosesum — Mon, 30 Jul 2012 17:43:30 GMT

Cell A1 = 11

Cell B1 = 21

Cell C1 = 1121 formula =CONCATENATE(A1,B1) or =VALUE(CONCATENATE(A1,B1))

If you have pairs that begin with a zero such as 01 through 09 you might want to do the following:

Right click cell C1.

Select Format Cells

Click the Number Tab

In the Category box select Custom

To the right under Type click the 0 (zero) then add 3 additional zeroes to total 4 zeroes

Click the OK button

Reply #4

dannyboyhouston — Mon, 30 Jul 2012 01:48:55 GMT

Hey Gas, you have to go to the cell and format the cell using the Function Wizard next to your input area, when the drop down menue comes up, scroll down until you get to concatenate. You then enter the cell references as such; a1 b1 make sure there is space between the cell referenec and the ' ' mark. Good luck.

Danny

Reply #3

miss9 — Mon, 30 Jul 2012 00:49:40 GMT

I guess you don't want to just put

=A1 B1

in the third cell

Reply #2

GASMETERGUY — Mon, 30 Jul 2012 00:35:33 GMT

I tried the record a macro but that did not work.

I am thinking I will need to convert the number to text, then append the two cells. After appending, I might be able to convert the text back to a number.

But I am open to other suggestions.

Reply #1

SergeM — Sun, 29 Jul 2012 19:51:39 GMT

In VBA you can write a sub or a function .

You can record a macro and start from there.

On the sheet you can use a text function or ampersand (' ').

Excel request

GASMETERGUY — Sun, 29 Jul 2012 18:09:09 GMT