add text of 2 columns in Excel A+B=AB

[Revwd40]

I need to merge the exact contents of 2 columns in Excel......I do not want
to sum the data........just to merge it......ie A + B = AB..........any
suggestions.......I am a mediun level user.......tried strings, concentate,
etc. Thanks.

 

[Ev]

=CONCATENATE(A,B)

 

[Peo Sjoblom]

Or somwehat sorter to type <g>
=A&B

Regards,

Peo Sjoblom

 

[Revwd40]

Could not make it work.....it would simply show the formula as typed.
The actual information is as such.......column b has info such as 1401.001
and column e has information such as .162

My desire is to merge the two columns to end up with 1401.001.162
I am creating SKU numbers for an inventory control application.......the
first number represents the in house part number......the second number
represents a physical location from a site grid........this would pinpoint
the exact location of each item. I am then going to import the data into a
bar code system to generate in house labels to use with scanning software.

Thanks again for any thoughts.

 

[Ev]

Make sure the colums are formatted as text

Could not make it work.....it would simply show the formula as typed.
The actual information is as such.......column b has info such as
1401.001
and column e has information such as .162

My desire is to merge the two columns to end up with 1401.001.162
I am creating SKU numbers for an inventory control application.......the
first number represents the in house part number......the second number
represents a physical location from a site grid........this would pinpoint
the exact location of each item. I am then going to import the data into a
bar code system to generate in house labels to use with scanning software.

Thanks again for any thoughts.

 

[Revwd40]

Did that......just now went back and tried again.......formatted as
text......even took the periods (decimals) out......made no
difference........all it gives is the typed formula in the destination cell.

Thanks

 

[Ev]

Not sure then, It is working fine for me

Did that......just now went back and tried again.......formatted as
text......even took the periods (decimals) out......made no
difference........all it gives is the typed formula in the destination
cell.

Thanks

 

[Gord Dibben]

Seeing the typed formula in the cell means.......

1. You have "View Formulas" toggled on. Hit CRTL + ` to toggle off.

OR

2. The cell with the formula was pre-formatted as text. Select the cell and
format as General.

With cell selected hit F2 then <ENTER> to re-enter the formula.

Your formula in C1 should be =B1 & E1

Note: .162 will show up as 0.162 unless formatted as text prior to entry.

Double-click on the fill handle of C1 to replicate this formula down to end of
data in column B.

Gord Dibben Excel MVP

 

[Revwd40]

Tried as you suggested.........did not work.........

Is this concatenate function supported in Excel 2002? I can make it add
the data from these two rows........will try it tomorrow on a different
machine running a later version and see..........thanks for all the
input........will advise of my results.

Regards.

 

[Frank Kabel]

Hi
it is supported in Excel 2002
Probably really only a formating issue:
1. Change the format of this cell to 'General'
2. Re-enter the formula anew in this cell

 

[Gord Dibben]

CONCATENATE Function is supported in 2002(and much earlier versions)

"Did not work" means what?

View Formulas is on or off?

Was the formula cell formatted as text?

=A&B certainly will not work......returns #NAME! as it should.

You cannot Concatenate entire rows or columns in this manner.

=A1&B1 will work if A1 and B1 contain data.

Note the "&" is used, not the "+" sign.

Gord