View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default How do I merge cells with different information?

Assuming source data in cols A to D
In E1: =A1&" "&B1&" "&C1&"-"&D1
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Linds" wrote:
I have 4 columns with information for seat locations (section, row, seat #,
seat #) and I need all four pieces of information in one cell. Is there any
function or trick for me to get these four pieces of data in one cell?

Right now I am typing in the row and seat numbers in the cell with the
section number and merging those. I have about 5000 accounts to do this with
and was curious of any shortcuts. Here is how I need the cell to read for
example:
106 BB 1-4.

Thanks!