View Single Post
  #5   Report Post  
Batmans_Wife
 
Posts: n/a
Default

Thanks for sending the link to your page with the macros and instructions.
It's very detailed and thorough. Although I was able to figure it out with
the formula that Peo posted earlier, I appreciate your further information
and will keep it handy for future use.

Sincerely,
Michelle

"JE McGimpsey" wrote:

To concatenate in place, you can use a macro like the one found he

http://www.mcgimpsey.com/excel/mergedata.html


In article ,
Batmans_Wife wrote:

I'm highlighting two cells in the same row, hitting format cells, alignment,
merge cells and I'm getting the error message, "The selection contains
multiple data values. Merging into one cell will keep the upper-left most
data only." I want to be able to make the two seperate cells one without
deleting anything and without having to cut and paste.