Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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. |
#8
|
|||
|
|||
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 |
#9
|
|||
|
|||
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. |
#10
|
|||
|
|||
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 |
#11
|
|||
|
|||
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 |
#12
|
|||
|
|||
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 |
#13
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
no row numbers or column letters DISPLAYED | Excel Discussion (Misc queries) | |||
Excel column headings from numbers to letters | Excel Discussion (Misc queries) | |||
Finding Numbers with Cells that also contain letters | Excel Discussion (Misc queries) | |||
how to sum up letters instead of numbers? | Excel Discussion (Misc queries) | |||
How do I change column labels from numbers to letters in Excel? | Excel Discussion (Misc queries) |