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

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.

=CONCATENATE(A,B)

"Revwd40" wrote in message
...
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.

Or somwehat sorter to type <g
=A&B

Regards,

Peo Sjoblom

"Ev" wrote:


=CONCATENATE(A,B)

"Revwd40" wrote in message
...
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.

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.

"Peo Sjoblom" wrote:

Or somwehat sorter to type <g
=A&B

Regards,

Peo Sjoblom

"Ev" wrote:


=CONCATENATE(A,B)

"Revwd40" wrote in message
...
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.

Make sure the colums are formatted as text


"Revwd40" wrote in message
...
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.

"Peo Sjoblom" wrote:

Or somwehat sorter to type <g
=A&B

Regards,

Peo Sjoblom

"Ev" wrote:


=CONCATENATE(A,B)

"Revwd40" wrote in message
...
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.

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" wrote:

Make sure the colums are formatted as text


"Revwd40" wrote in message
...
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.

"Peo Sjoblom" wrote:

Or somwehat sorter to type <g
=A&B

Regards,

Peo Sjoblom

"Ev" wrote:


=CONCATENATE(A,B)

"Revwd40" wrote in message
...
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.

Not sure then, It is working fine for me


"Revwd40" wrote in message
...
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" wrote:

Make sure the colums are formatted as text


"Revwd40" wrote in message
...
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.

"Peo Sjoblom" wrote:

Or somwehat sorter to type <g
=A&B

Regards,

Peo Sjoblom

"Ev" wrote:


=CONCATENATE(A,B)

"Revwd40" wrote in message
...
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.

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

On Tue, 28 Dec 2004 14:57:02 -0800, "Revwd40"
wrote:

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" wrote:

Make sure the colums are formatted as text


"Revwd40" wrote in message
...
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.

"Peo Sjoblom" wrote:

Or somwehat sorter to type <g
=A&B

Regards,

Peo Sjoblom

"Ev" wrote:


=CONCATENATE(A,B)

"Revwd40" wrote in message
...
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.

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.


"Gord Dibben" wrote:

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

On Tue, 28 Dec 2004 14:57:02 -0800, "Revwd40"
wrote:

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" wrote:

Make sure the colums are formatted as text


"Revwd40" wrote in message
...
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.

"Peo Sjoblom" wrote:

Or somwehat sorter to type <g
=A&B

Regards,

Peo Sjoblom

"Ev" wrote:


=CONCATENATE(A,B)

"Revwd40" wrote in message
...
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.

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

--
Regards
Frank Kabel
Frankfurt, Germany
"Revwd40" schrieb im Newsbeitrag
...
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.


"Gord Dibben" wrote:

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

On Tue, 28 Dec 2004 14:57:02 -0800, "Revwd40"
wrote:

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" wrote:

Make sure the colums are formatted as text


"Revwd40" wrote in message
...
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.

"Peo Sjoblom" wrote:

Or somwehat sorter to type <g
=A&B

Regards,

Peo Sjoblom

"Ev" wrote:


=CONCATENATE(A,B)

"Revwd40" wrote in message
...
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.

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

On Tue, 28 Dec 2004 19:59:03 -0800, "Revwd40"
wrote:

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.


"Gord Dibben" wrote:

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

On Tue, 28 Dec 2004 14:57:02 -0800, "Revwd40"
wrote:

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" wrote:

Make sure the colums are formatted as text


"Revwd40" wrote in message
...
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.

"Peo Sjoblom" wrote:

Or somwehat sorter to type <g
=A&B

Regards,

Peo Sjoblom

"Ev" wrote:


=CONCATENATE(A,B)

"Revwd40" wrote in message
...
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.