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

Ardus;
Thanks very much it is working perfectly.

Maperalia

"Ardus Petus" wrote:

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