View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joerg Mochikun Joerg Mochikun is offline
external usenet poster
 
Posts: 104
Default obtaining info from multiple cells from different workbooks.


=[Book1]Sheet1!A12&" "&[Book1]Sheet1!A13

Cheers,
Joerg

"Dave" <Dave @discussions.microsoft.com wrote in message
...
Hey All,
Don't know if this is the right group to ask this in.
Anyway, I'm trying to get info from multiple cells from workbook 1 sheet 1
cells A12 and A13 into worksheet 2 sheet 1 cell A5 with a space between
the
2 info cells... is this possible or can you only get info from 1 cell w/o
spaces??