Mirroring WORDS? help!

Question

I have this cell that a client can put in an answer to a question. But the answer is in words. But i need that answer for a summary in another cell. I know you can mirror cells with values (numbers), But how can I make a cell mirror a word.

What I mean is:

If I put the word              yes (or ANY other word)               in cell A1, that word will be mirrored on cell A2.

Basically if it were numbers being put in the formula we would use in cell A2 would be         =SUM(A1)         , I need that exact same thing but just that instead of number is mirrors words.

I need this for:

The formula will be put in cells    C7    and E7      , and they will be mirroring cell H28.

So if a WORD is put in cell H28. That SAME WORD will be shown in cells C7 and E7. No matter how many times the word is changed in cell H28.

I would really appreciate if someone could please help me.

PLEASE HELP and THANK YOU!

Answer 1

Basically if it were numbers being put in the formula we would use in cell A2 would be         =SUM(A1)         , I need that exact same thing but just that instead of number is mirrors words.

 

You would not need the SUM function to display the value in A1... since it is only a single value, there is nothing to add, so you could just use this instead...

=A1

What that does is display whatever is in A1... note I said "whatever is in A1"... it works whether A1 contains numbers, dates, text or whatever. So, the answer to your question (assuming I understand your use of the word "mirroring" correctly) is to put this...

=H28

in both C7 and E7.

Answer 2

Thats weird I tried and it didnt work, now it does. Thank you!

You are welcome. Since it solved your problem, would you please mark my previous message as the "Answer".

Answer 3

Thats weird I tried and it didnt work, now it does. Thank you!