View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
 
Posts: 718
Default How can I get a value from two cells into the new cell.

enter following formula in B1:
=A1&" @"&A2&".xls"

HTH
--
AP

"maperalia" a écrit dans le message de
...
Basically, I want to take the value from the cell A1 and cell A2 and type

it
in the cell B1.
For example, if the cell A1=Core and cell A2=50; I want to get in the cell
B1 the following:
Core @ 50.xls

If this possible to do this?

Thanks in advance.
Maperalia