Re: $$Excel-Macros$$ IN THE SENTENCE REQUIRE ONE CELL VALUE

2010-06-21 Thread Dharmesh Shah
Dear group Please help in attached excel file. Regards Dharmesh Shah On Thu, Jun 17, 2010 at 12:57 AM, Michael Hayes 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 nee

Re: $$Excel-Macros$$ IN THE SENTENCE REQUIRE ONE CELL VALUE

2010-06-16 Thread Michael Hayes
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 wrote: > this should help. see attached file > > Warm

Re: $$Excel-Macros$$ IN THE SENTENCE REQUIRE ONE CELL VALUE

2010-06-15 Thread Harmeet Singh
this should help. see attached file Warm Regards, Harmeet Singh On Tue, Jun 15, 2010 at 6:43 PM, big smile 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

$$Excel-Macros$$ IN THE SENTENCE REQUIRE ONE CELL VALUE

2010-06-15 Thread big smile
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