Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What function to copy text to another cell?
I want to say in one instance:
I type 'GREEN' in cell A1, and in cell B1 I want a function to = whatever I type in A1, so when I press the enter key in A1, B1 also shows the word "GREEN" ? The second one is more complicated! I want to say: If cell A1 0 , then show the text contained in cell B1 in cell C1. What function do I type into C1 ? Please Help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What function to copy text to another cell?
On Oct 3, 4:10 am, dim wrote:
I want to say in one instance: I type 'GREEN' in cell A1, and in cell B1 I want a function to = whatever I type in A1, so when I press the enter key in A1, B1 also shows the word "GREEN" ? The second one is more complicated! I want to say: If cell A1 0 , then show the text contained in cell B1 in cell C1. What function do I type into C1 ? Please Help! 1st question =A1 2nd =if(a10,b1,a1) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
What function to copy text to another cell?
Hi dim,
For first, u can give =A1 in the cell B1. So that you will get same value in both the cells. For the second, u can give the following formula in C1, =IF(A10,B1) Hope this will clear your doubts. Regards, Soundar "dim" wrote: I want to say in one instance: I type 'GREEN' in cell A1, and in cell B1 I want a function to = whatever I type in A1, so when I press the enter key in A1, B1 also shows the word "GREEN" ? The second one is more complicated! I want to say: If cell A1 0 , then show the text contained in cell B1 in cell C1. What function do I type into C1 ? Please Help! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
What function to copy text to another cell?
LOL, I was making things soooo much more complicated than necessary. Trying
to transfer text instead of numeric values somehow caused a brain freeze! Those methods worked....obviously...you knew they would...anyway! :-D Thanks again. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find text in a cell and copy text to another cell | Excel Discussion (Misc queries) | |||
Copy a text from one tab to another using a function | Excel Worksheet Functions | |||
Copy text from cell to cell with one cell changing text | Excel Worksheet Functions | |||
In a function, How do I copy the cell color as well as text | Excel Worksheet Functions | |||
Copy text from text box to cell in another worksheet | Excel Worksheet Functions |