How can I merge 2 cells with numbers and letters?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
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.
 
Hi Fantasma,

I suspect that cell C1 is formatted as text.

Try formatting C1 as general and re-enter the formula.
 
Make sure you don't use leading spaces in your formula:

" =a1&b1 " without the quotes should be:
"=a1&b1" without the quotes
 
No, all three cells are formatted as "general". Other suggestions ??

====================================
 
I have no spaces in the formula ... preceding or within the formula.
 
Hi Fantasma,

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

Tools|options|View Tab
Uncheck Formulas if it's checked.
 
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.
 
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 said:
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.
Click to expand...
 
Darn cats! <vbg>
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
How to count merged cells 1
Counting Merged Cells 5
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
Excel Convert word into numbers and back 4
Format Cell using letter & number to use in mail merge 2
number to character and vice-versa 8
Merged cells disturb autofilter indicator 2

Back
Top