Dear group Please help in attached excel file.
Regards
Dharmesh Shah
On Thu, Jun 17, 2010 at 12:57 AM, Michael Hayes <m99pan...@gmail.com> wrote:
> 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
>
--
----------------------------------------------------------------------------------
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
eg(1).xls
Description: MS-Excel spreadsheet
