I would like to merge an alpha field with a numberic field. Not sure it this
is possible.
Thanks
I would like to merge an alpha field with a numberic field. Not sure it this
is possible.
Thanks
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
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
One more:
=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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks