View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default How to I copy text from a range of cells to another single cell?

In article ,
WRT wrote:

I am unable to copy the entered code (text) from C20:C25 Please be aware
that if the entered number in A20:A25 is 3 (hypothetically) this does not
mean that the code (text) in C20:C25 will always be G (or any other code each
and every time).


Then you need to explain how the formula should determine which code
goes in the cell...