How can I merge 2 cells with numbers and letters?
 

I was able to separate a column into 3 components ... (3 columns) ... and now
I want to re-combine two of them. I've tried to follow instructions for this
in the HELP area but cannot merge the two columns. (One contains 4
alpabetical letters, the other 4 or 5 numbers.)

How can I do this?? I'm using the latest version of Excel w/ XP.

=a1&b1
or
=a1&" "&b1
or
=a1&" "&text(b1,"00000")
or
=a1&" Has a balance due of: " & text(b1,"$#,##0.00")

A1 holds the text and B1 holds the number

fantasma wrote:

I was able to separate a column into 3 components ... (3 columns) ... and now
I want to re-combine two of them. I've tried to follow instructions for this
in the HELP area but cannot merge the two columns. (One contains 4
alpabetical letters, the other 4 or 5 numbers.)

How can I do this?? I'm using the latest version of Excel w/ XP.

--

Dave Peterson

Hi Fantasma,

Assume the numerals are in Col B and the alphas are in Col C

=B1 & C1 (Concatenate without a space)

or

=B1 & " " & C1 (Concatenate with a space)


---
Regards,
Norman



"fantasma" wrote in message
...
I was able to separate a column into 3 components ... (3 columns) ... and
now
I want to re-combine two of them. I've tried to follow instructions for
this
in the HELP area but cannot merge the two columns. (One contains 4
alpabetical letters, the other 4 or 5 numbers.)

How can I do this?? I'm using the latest version of Excel w/ XP.

Thanks for the feed back. Unforunately, I've not been able to get either of
the techniques to work. (I tried the same when it was outlined MS Help
area.) Do I need to "activate" something or some how enable the
"concatenate" function? Assuming I have 4 numbers in A1 and 4 letters in B1
.... I'm typing " =a1&b1 " (without quotation marks) in cell C1 .... and all
I get is "=a1&b1" (again, w/o quotation marks).

Any other suggestions? Perhaps I have something 'over-riding' the function
that needs to be changes?

Any comments will be appreciated.



"Norman Jones" wrote:

Hi Fantasma,

Assume the numerals are in Col B and the alphas are in Col C

=B1 & C1 (Concatenate without a space)

or

=B1 & " " & C1 (Concatenate with a space)


---
Regards,
Norman



"fantasma" wrote in message
...
I was able to separate a column into 3 components ... (3 columns) ... and
now
I want to re-combine two of them. I've tried to follow instructions for
this
in the HELP area but cannot merge the two columns. (One contains 4
alpabetical letters, the other 4 or 5 numbers.)

How can I do this?? I'm using the latest version of Excel w/ XP.

Hi Fantasma,

I suspect that cell C1 is formatted as text.

Try formatting C1 as general and re-enter the formula.

---
Regards,
Norman



"fantasma" wrote in message
...
Thanks for the feed back. Unforunately, I've not been able to get either
of
the techniques to work. (I tried the same when it was outlined MS Help
area.) Do I need to "activate" something or some how enable the
"concatenate" function? Assuming I have 4 numbers in A1 and 4 letters in
B1
... I'm typing " =a1&b1 " (without quotation marks) in cell C1 .... and
all
I get is "=a1&b1" (again, w/o quotation marks).

Any other suggestions? Perhaps I have something 'over-riding' the
function
that needs to be changes?

Any comments will be appreciated.



"Norman Jones" wrote:

Hi Fantasma,

Assume the numerals are in Col B and the alphas are in Col C

=B1 & C1 (Concatenate without a space)

or

=B1 & " " & C1 (Concatenate with a space)


---
Regards,
Norman



"fantasma" wrote in message
...
I was able to separate a column into 3 components ... (3 columns) ...
and
now
I want to re-combine two of them. I've tried to follow instructions
for
this
in the HELP area but cannot merge the two columns. (One contains 4
alpabetical letters, the other 4 or 5 numbers.)

How can I do this?? I'm using the latest version of Excel w/ XP.

Make sure you don't use leading spaces in your formula:

" =a1&b1 " without the quotes should be:
"=a1&b1" without the quotes



fantasma wrote:

Thanks for the feed back. Unforunately, I've not been able to get either of
the techniques to work. (I tried the same when it was outlined MS Help
area.) Do I need to "activate" something or some how enable the
"concatenate" function? Assuming I have 4 numbers in A1 and 4 letters in B1
... I'm typing " =a1&b1 " (without quotation marks) in cell C1 .... and all
I get is "=a1&b1" (again, w/o quotation marks).

Any other suggestions? Perhaps I have something 'over-riding' the function
that needs to be changes?

Any comments will be appreciated.

"Norman Jones" wrote:

Hi Fantasma,

Assume the numerals are in Col B and the alphas are in Col C

=B1 & C1 (Concatenate without a space)

or

=B1 & " " & C1 (Concatenate with a space)


---
Regards,
Norman



"fantasma" wrote in message
...
I was able to separate a column into 3 components ... (3 columns) ... and
now
I want to re-combine two of them. I've tried to follow instructions for
this
in the HELP area but cannot merge the two columns. (One contains 4
alpabetical letters, the other 4 or 5 numbers.)

How can I do this?? I'm using the latest version of Excel w/ XP.




--

Dave Peterson

No, all three cells are formatted as "general". Other suggestions ??

====================================

"Norman Jones" wrote:

Hi Fantasma,

I suspect that cell C1 is formatted as text.

Try formatting C1 as general and re-enter the formula.

---
Regards,
Norman



"fantasma" wrote in message
...
Thanks for the feed back. Unforunately, I've not been able to get either
of
the techniques to work. (I tried the same when it was outlined MS Help
area.) Do I need to "activate" something or some how enable the
"concatenate" function? Assuming I have 4 numbers in A1 and 4 letters in
B1
... I'm typing " =a1&b1 " (without quotation marks) in cell C1 .... and
all
I get is "=a1&b1" (again, w/o quotation marks).

Any other suggestions? Perhaps I have something 'over-riding' the
function
that needs to be changes?

Any comments will be appreciated.



"Norman Jones" wrote:

Hi Fantasma,

Assume the numerals are in Col B and the alphas are in Col C

=B1 & C1 (Concatenate without a space)

or

=B1 & " " & C1 (Concatenate with a space)


---
Regards,
Norman



"fantasma" wrote in message
...
I was able to separate a column into 3 components ... (3 columns) ...
and
now
I want to re-combine two of them. I've tried to follow instructions
for
this
in the HELP area but cannot merge the two columns. (One contains 4
alpabetical letters, the other 4 or 5 numbers.)

How can I do this?? I'm using the latest version of Excel w/ XP.

I have no spaces in the formula ... preceding or within the formula.

"Dave Peterson" wrote:

Make sure you don't use leading spaces in your formula:

" =a1&b1 " without the quotes should be:
"=a1&b1" without the quotes



fantasma wrote:

Thanks for the feed back. Unforunately, I've not been able to get either of
the techniques to work. (I tried the same when it was outlined MS Help
area.) Do I need to "activate" something or some how enable the
"concatenate" function? Assuming I have 4 numbers in A1 and 4 letters in B1
... I'm typing " =a1&b1 " (without quotation marks) in cell C1 .... and all
I get is "=a1&b1" (again, w/o quotation marks).

Any other suggestions? Perhaps I have something 'over-riding' the function
that needs to be changes?

Any comments will be appreciated.

"Norman Jones" wrote:

Hi Fantasma,

Assume the numerals are in Col B and the alphas are in Col C

=B1 & C1 (Concatenate without a space)

or

=B1 & " " & C1 (Concatenate with a space)


---
Regards,
Norman



"fantasma" wrote in message
...
I was able to separate a column into 3 components ... (3 columns) ... and
now
I want to re-combine two of them. I've tried to follow instructions for
this
in the HELP area but cannot merge the two columns. (One contains 4
alpabetical letters, the other 4 or 5 numbers.)

How can I do this?? I'm using the latest version of Excel w/ XP.




--

Dave Peterson

Hi Fantasma,

What happens if you enter data in cells A1 and B1 in a another (blamk)
worksheet and then retry the formula?

---
Regards,
Norman



"Norman Jones" wrote in message
...
Hi Fantasma,

I suspect that cell C1 is formatted as text.

Try formatting C1 as general and re-enter the formula.

---
Regards,
Norman



"fantasma" wrote in message
...
Thanks for the feed back. Unforunately, I've not been able to get either
of
the techniques to work. (I tried the same when it was outlined MS Help
area.) Do I need to "activate" something or some how enable the
"concatenate" function? Assuming I have 4 numbers in A1 and 4 letters in
B1
... I'm typing " =a1&b1 " (without quotation marks) in cell C1 .... and
all
I get is "=a1&b1" (again, w/o quotation marks).

Any other suggestions? Perhaps I have something 'over-riding' the
function
that needs to be changes?

Any comments will be appreciated.



"Norman Jones" wrote:

Hi Fantasma,

Assume the numerals are in Col B and the alphas are in Col C

=B1 & C1 (Concatenate without a space)

or

=B1 & " " & C1 (Concatenate with a space)


---
Regards,
Norman



"fantasma" wrote in message
...
I was able to separate a column into 3 components ... (3 columns) ...
and
now
I want to re-combine two of them. I've tried to follow instructions
for
this
in the HELP area but cannot merge the two columns. (One contains 4
alpabetical letters, the other 4 or 5 numbers.)

How can I do this?? I'm using the latest version of Excel w/ XP.

Are you viewing formulas?

Tools|options|View Tab
Uncheck Formulas if it's checked.



fantasma wrote:

I have no spaces in the formula ... preceding or within the formula.

"Dave Peterson" wrote:

Make sure you don't use leading spaces in your formula:

" =a1&b1 " without the quotes should be:
"=a1&b1" without the quotes



fantasma wrote:

Thanks for the feed back. Unforunately, I've not been able to get either of
the techniques to work. (I tried the same when it was outlined MS Help
area.) Do I need to "activate" something or some how enable the
"concatenate" function? Assuming I have 4 numbers in A1 and 4 letters in B1
... I'm typing " =a1&b1 " (without quotation marks) in cell C1 .... and all
I get is "=a1&b1" (again, w/o quotation marks).

Any other suggestions? Perhaps I have something 'over-riding' the function
that needs to be changes?

Any comments will be appreciated.

"Norman Jones" wrote:

Hi Fantasma,

Assume the numerals are in Col B and the alphas are in Col C

=B1 & C1 (Concatenate without a space)

or

=B1 & " " & C1 (Concatenate with a space)


---
Regards,
Norman



"fantasma" wrote in message
...
I was able to separate a column into 3 components ... (3 columns) ... and
now
I want to re-combine two of them. I've tried to follow instructions for
this
in the HELP area but cannot merge the two columns. (One contains 4
alpabetical letters, the other 4 or 5 numbers.)

How can I do this?? I'm using the latest version of Excel w/ XP.




--

Dave Peterson


--

Dave Peterson

HEY! That did it! Thanks! Question: Do you think I must have erroneously
checked this at some point in time? This computer/Excel program is only a
few months old ...... but I've done calculations with it previously. (Maybe
I erroneously turned it on when trying to get this working??) Any comments
as to how this went wrong??

Thanks for your help.



"Dave Peterson" wrote:

Are you viewing formulas?

Tools|options|View Tab
Uncheck Formulas if it's checked.



fantasma wrote:

I have no spaces in the formula ... preceding or within the formula.

"Dave Peterson" wrote:

Make sure you don't use leading spaces in your formula:

" =a1&b1 " without the quotes should be:
"=a1&b1" without the quotes



fantasma wrote:

Thanks for the feed back. Unforunately, I've not been able to get either of
the techniques to work. (I tried the same when it was outlined MS Help
area.) Do I need to "activate" something or some how enable the
"concatenate" function? Assuming I have 4 numbers in A1 and 4 letters in B1
... I'm typing " =a1&b1 " (without quotation marks) in cell C1 .... and all
I get is "=a1&b1" (again, w/o quotation marks).

Any other suggestions? Perhaps I have something 'over-riding' the function
that needs to be changes?

Any comments will be appreciated.

"Norman Jones" wrote:

Hi Fantasma,

Assume the numerals are in Col B and the alphas are in Col C

=B1 & C1 (Concatenate without a space)

or

=B1 & " " & C1 (Concatenate with a space)


---
Regards,
Norman



"fantasma" wrote in message
...
I was able to separate a column into 3 components ... (3 columns) ... and
now
I want to re-combine two of them. I've tried to follow instructions for
this
in the HELP area but cannot merge the two columns. (One contains 4
alpabetical letters, the other 4 or 5 numbers.)

How can I do this?? I'm using the latest version of Excel w/ XP.




--

Dave Peterson


--

Dave Peterson

There is a hotkey to toggle this feature. It is ctrl` that's the key on the
top row next to 1. Maybe the cat was walking on the keyboard again.:)

Carlos

"fantasma" wrote in message
...
HEY! That did it! Thanks! Question: Do you think I must have
erroneously
checked this at some point in time? This computer/Excel program is only a
few months old ...... but I've done calculations with it previously.
(Maybe
I erroneously turned it on when trying to get this working??) Any
comments
as to how this went wrong??

Thanks for your help.



"Dave Peterson" wrote:

Are you viewing formulas?

Tools|options|View Tab
Uncheck Formulas if it's checked.



fantasma wrote:

I have no spaces in the formula ... preceding or within the formula.

"Dave Peterson" wrote:

Make sure you don't use leading spaces in your formula:

" =a1&b1 " without the quotes should be:
"=a1&b1" without the quotes



fantasma wrote:

Thanks for the feed back. Unforunately, I've not been able to get
either of
the techniques to work. (I tried the same when it was outlined MS
Help
area.) Do I need to "activate" something or some how enable the
"concatenate" function? Assuming I have 4 numbers in A1 and 4
letters in B1
... I'm typing " =a1&b1 " (without quotation marks) in cell C1
..... and all
I get is "=a1&b1" (again, w/o quotation marks).

Any other suggestions? Perhaps I have something 'over-riding'
the function
that needs to be changes?

Any comments will be appreciated.

"Norman Jones" wrote:

Hi Fantasma,

Assume the numerals are in Col B and the alphas are in Col C

=B1 & C1 (Concatenate without a space)

or

=B1 & " " & C1 (Concatenate with a space)


---
Regards,
Norman



"fantasma" wrote in message
...
I was able to separate a column into 3 components ... (3
columns) ... and
now
I want to re-combine two of them. I've tried to follow
instructions for
this
in the HELP area but cannot merge the two columns. (One
contains 4
alpabetical letters, the other 4 or 5 numbers.)

How can I do this?? I'm using the latest version of Excel w/
XP.




--

Dave Peterson


--

Dave Peterson

Darn cats! <vbg

CarlosAntenna wrote:

There is a hotkey to toggle this feature. It is ctrl` that's the key on the
top row next to 1. Maybe the cat was walking on the keyboard again.:)

Carlos

"fantasma" wrote in message
...
HEY! That did it! Thanks! Question: Do you think I must have
erroneously
checked this at some point in time? This computer/Excel program is only a
few months old ...... but I've done calculations with it previously.
(Maybe
I erroneously turned it on when trying to get this working??) Any
comments
as to how this went wrong??

Thanks for your help.



"Dave Peterson" wrote:

Are you viewing formulas?

Tools|options|View Tab
Uncheck Formulas if it's checked.



fantasma wrote:

I have no spaces in the formula ... preceding or within the formula.

"Dave Peterson" wrote:

Make sure you don't use leading spaces in your formula:

" =a1&b1 " without the quotes should be:
"=a1&b1" without the quotes



fantasma wrote:

Thanks for the feed back. Unforunately, I've not been able to get
either of
the techniques to work. (I tried the same when it was outlined MS
Help
area.) Do I need to "activate" something or some how enable the
"concatenate" function? Assuming I have 4 numbers in A1 and 4
letters in B1
... I'm typing " =a1&b1 " (without quotation marks) in cell C1
.... and all
I get is "=a1&b1" (again, w/o quotation marks).

Any other suggestions? Perhaps I have something 'over-riding'
the function
that needs to be changes?

Any comments will be appreciated.

"Norman Jones" wrote:

Hi Fantasma,

Assume the numerals are in Col B and the alphas are in Col C

=B1 & C1 (Concatenate without a space)

or

=B1 & " " & C1 (Concatenate with a space)


---
Regards,
Norman



"fantasma" wrote in message
...
I was able to separate a column into 3 components ... (3
columns) ... and
now
I want to re-combine two of them. I've tried to follow
instructions for
this
in the HELP area but cannot merge the two columns. (One
contains 4
alpabetical letters, the other 4 or 5 numbers.)

How can I do this?? I'm using the latest version of Excel w/
XP.




--

Dave Peterson


--

Dave Peterson


--

Dave Peterson