Hameet,
Try the concatenate function
=CONCATENATE("I have "&B1&" hands and "&C1&" Eyes")
Notice the spaces for the text inside the quotation marks...you need
those spaces to format your sentence properly.
On Jun 15, 6:37 pm, Harmeet Singh <harmeet.hew...@gmail.com> wrote:
> this should help. see attached file
>
> Warm Regards,
>
> Harmeet Singh
>
>
>
> On Tue, Jun 15, 2010 at 6:43 PM, big smile <bigsmile...@gmail.com> wrote:
> > Hellow Friends
>
> > Can it possible that
>
> > in cell lets ex. in B1 I write -----
>
> > The gross total is Rs. ---[ Cell value of A1 ].
>
> > In between any sentence i want the cell value from any other cell.
>
> > can it possible in between the cell also.
>
> > For ex. -- The gross total is Rs. [ c1] & the gross weight is Rs. [ c2]
>
> > where c1 & c2 is the cell value
>
> > Thanks
>
> > Good Day
> > From Big Smile
> > Savla
>
> > --
>
> > ---------------------------------------------------------------------------
> > -------
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 7000 subscribers worldwide and receive many nice notes about
> > the learning and support from the group.Let friends and co-workers know they
> > can subscribe to group at
> >http://groups.google.com/group/excel-macros/subscribe
>
>
>
> eg.xls
> 18KViewDownload
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
