Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Merge an alpha field and a numeric field
I would like to merge an alpha field with a numberic field. Not sure it this
is possible. Thanks |
#2
|
|||
|
|||
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 "grams" wrote: I would like to merge an alpha field with a numberic field. Not sure it this is possible. Thanks |
#3
|
|||
|
|||
Try =concatenate(a1,b2)
"grams" wrote: I would like to merge an alpha field with a numberic field. Not sure it this is possible. Thanks |
#4
|
|||
|
|||
One mo
=a1&" "&text(a2,"$0.00") or =a1&" is due on: " & text(a2,"mm/dd/yyyy") grams wrote: I would like to merge an alpha field with a numberic field. Not sure it this is possible. Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
joing (merge) tables by key field | Excel Worksheet Functions | |||
how do i step thru a text field looking for 6 numeric characters | Excel Worksheet Functions | |||
Sort a numeric field | Excel Discussion (Misc queries) | |||
How to filter on a date field during mail merge | Excel Worksheet Functions | |||
F7 in zip field when doing mail merge from excell file | Excel Discussion (Misc queries) |