Excel question

[Xcrown]

Does anyone know how you can make an excel function that will place the result of one cell into a different cell so that the result column or row has just the result numbers to be easily copied and pasted? Is that clear enough?? Thanks to anyone who knows this.

Xcrown

 

[tkdkid]

not sure, but =[Column][Row] might work.

try putting =A5 for example in one cell.

 

[GasX]

not clear enough

 

[Xcrown]

Heres what Im doing. Ive set up a function so that I can just quickly type in some numbers and then it applies the function. Now, I need the result of this function to be placed into cells that have no function in them so that I can copy and paste them somewhere else for just the numbers and not the function. little clearer??

Xcrown

 

[kranky]

I'm not sure I'm following you, but can you use Edit -> Paste Special and just select Values to get what you want?

 

[Xcrown]

YES. Thats it. Thanks for the tip.

Xcrown