Thread: Combine 2 cells to match a predefined name?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Combine 2 cells to match a predefined name?
Clarification
=INDIRECT("Inc."&A1)
presumes A1 will contain only: 2007

If you have the full string entered in A1, ie: Inc.2007
then just use: =INDIRECT(A1)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---
Reply With QuoteReply With Quote