How to Display one cell Text in another Cell in Excel?

Question

0.00/5 (No votes)

See more:

Hi...
I have a text in A2 cell i.e., Soap
i have text in C2 Cell i.e 10....
now i want to display two this text in G3, it should be like soap Cost Rs. 10/- Only....
like this i should follow remaining items in my Ms Excel..
Please anyone Help Me regarding this.....

Posted 21-Nov-13 1:39am

Kumar Kovuru

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

♥…ЯҠ…♥ · Accepted Answer · 2013-11-21T01:51:00

Solution 1

Hi Kumar,

In EXCEL, its very simple, you can use CONCATENATE function.

1) Goto Formulas in Tool bar, Click spin arrow in Auto Sum --> Select more functions
2) Now select a category as TEXT
3) Select CONCATENATE function from below list box and click OK.
4) In Text1 select the cell that you have soap(A2) as text
5) In Text2 type " Cost Rs. "(without double quotes)
6) In Text3 select the cell 10(C2)
7) In Text4 type "/- Only...." (without double quotes

So thats it now you will get as per your requirement.

Hope this helps you a bit.

Regards,
RK

Posted 21-Nov-13 1:51am

♥…ЯҠ…♥

v2

Comments

Kumar Kovuru 21-Nov-13 8:03am

Superb......

♥…ЯҠ…♥ 21-Nov-13 8:21am

If its working, accept it as solution which might help someone.... and voting depends on your wish ;-)

Maciej Los 21-Nov-13 14:50pm

Excel formula concatenating tutorial ;)
+5!

♥…ЯҠ…♥ 21-Nov-13 22:58pm

Thanks Maciej....!!!! ;-)