Hi,
Use the below formula.
=A1&B1&TEXT(C1,("dd-mm-yy"))
On 10/26/08, karthik balasubramanian <[EMAIL PROTECTED]> wrote:
>
> 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
-~----------~----~----~----~------~----~------~--~---
