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:
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.
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
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
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
*=$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