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.