Merge an alpha field and a numeric field

G

grams

I would like to merge an alpha field with a numberic field. Not sure it this
is possible.

Thanks
 
B

Bob Umlas, Excel MVP

How do you want to merge them - put the 2 results into another cell? Then you
can use =A1&B1 (assuming the alpha & numeric fields are in A1 & B1!)
Do you mean Merge Cells? If 2 cells both contain data, then merging them
will only keep the data in the upper left cell.
Bob Umlas
Excel MVP
 
D

Dave Peterson

One more:

=a1&" "&text(a2,"$0.00")
or
=a1&" is due on: " & text(a2,"mm/dd/yyyy")
 
Top