Use this Function
Function ConCat(ParamArray arr() As Variant) As String For i = 0 To UBound(arr()) ConCat = ConCat & " " & Format(arr(i), arr(i).NumberFormat) Next End Function From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ICWAI Help Sent: Thursday, June 30, 2011 7:33 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How To Concatenate the Cell without loosing the format ="$"&ROUND(B3/1000,0)&" "&"GMRR"&""&"("&ROUND(D3,2)&"%"&""&"of the Plan)" find the attached file and formula it will works . On Thu, Jun 30, 2011 at 5:58 PM, Monu Tiwari <exce...@gmail.com> wrote: Awesome . thanks everyone ! On Thu, Jun 30, 2011 at 3:14 PM, ankur <ankurpande...@gmail.com> wrote: hi ak file is attached for reference Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Jun 30, 2011 at 3:10 PM, ankur <ankurpande...@gmail.com> wrote: > hi AK , use this formula, may it fullfill ur requirement.... use in F3 cell > =TEXT((C3/1000),"$#,#00")&"K"&" GMRR ("&ROUND((E3*100),0)&" % of the plan)" > > Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pandey > (Someone Different) > > I'm not the best but i'm not like the rest~~ > > > > On Thu, Jun 30, 2011 at 11:51 AM, Venkatesan c <venkat1....@gmail.com> wrote: >> >> Hi Ak, >> >> Find attached your query resolved.... >> >> Best Regards, >> Venkat >> >> On Thu, Jun 30, 2011 at 1:10 AM, Monu Tiwari <exce...@gmail.com> wrote: >>> >>> Hi Experts, >>> >>> >>> >>> I want to concatenate the different cells without losing the format of the >>> cells. Please refer the excel sheet for more details. >>> >>> Thanking you in Advance. >>> >>> >>> >>> Regards, >>> >>> AK >>> >>> -- >>> >>> ---------------------------------------------------------------------------- ------ >>> 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 <http://www.excel-macros.blogspot.com/> >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <http://exceldailytip.blogspot.com/> >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >> >> >> >> -- >> >> >> >> >> -- >> ---------------------------------------------------------------------------- ------ >> 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 <http://www.excel-macros.blogspot.com/> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <http://exceldailytip.blogspot.com/> >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > -- ---------------------------------------------------------------------------- ------ 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 <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <http://exceldailytip.blogspot.com/> To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------- ------ 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 <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <http://exceldailytip.blogspot.com/> To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------- ------ 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel