Hi,
Use this formulae:
=CONCATENATE(E17,F17,TEXT(G17,"[$-409]d-mmm-yyyy;@"))
COL: E F G ROW ms excel 24-oct-2008
E17 is ms
F17 is excel
g17 is 24-oct-2008
I hope this helps.
with regards
karthik.B
On Fri, Oct 24, 2008 at 1:01 AM, H Upadhyay <[EMAIL PROTECTED]>wrote:
> Pls chk attached file
>
> Regards
> Harish Upadhyay
>
>
>
> On 10/23/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>>
>> Hi All,
>>
>> I have an issue while using concatenate formula, Can any one of you help
>> me out with this:
>>
>> Query:
>>
>> Column A : MS
>> Column B : Excel
>> Column C : 24- Oct-08 ( formated as d-mmm-yy).
>>
>> When I use concatenate i get a result as : MS Excel 39745
>>
>> After formatting the cell too d-mmm-yy, I get the same result instead of
>> MS Excel 24-Oct-08.
>>
>> Please advice me if there is any other way out to get the result as
>> desired.
>>
>> Thanks in Advance
>>
>> Cheers
>> Shyam
>>
>>
>>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
