Home 
Search 
Today's Posts 
#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? ToolsoptionsView 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 'overriding' 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 recombine 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? ToolsoptionsView 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 'overriding' 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 recombine 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? ToolsoptionsView 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 'overriding' 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 recombine 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  
Excel column headings from numbers to letters  Excel Discussion (Misc queries)  
no row numbers or column letters DISPLAYED  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) 