Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
grams
 
Posts: n/a
Default 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   Report Post  
Bob Umlas, Excel MVP
 
Posts: n/a
Default

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   Report Post  
Mike
 
Posts: n/a
Default

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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
joing (merge) tables by key field Alex Kachanov Excel Worksheet Functions 1 August 27th 05 02:32 PM
how do i step thru a text field looking for 6 numeric characters Snookman150 Excel Worksheet Functions 0 June 30th 05 01:31 PM
Sort a numeric field sdmccabe Excel Discussion (Misc queries) 5 June 28th 05 08:54 AM
How to filter on a date field during mail merge SWADoug Excel Worksheet Functions 0 June 21st 05 06:31 PM
F7 in zip field when doing mail merge from excell file kshinn15 Excel Discussion (Misc queries) 0 April 16th 05 09:52 PM


All times are GMT +1. The time now is 02:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"