| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
unable to get expected results while anding two coloumns
A1=2/29/08,B1=ABC.=A1&B1.resulting in 39507abcab.how to get o/p as
2/29/2008abc in excel |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
unable to get expected results while anding two coloumns
Try this:
=TEXT(A1,"M/D/YYYY")&B1 Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "kingkhan" wrote in message ... A1=2/29/08,B1=ABC.=A1&B1.resulting in 39507abcab.how to get o/p as 2/29/2008abc in excel |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
unable to get expected results while anding two coloumns
On Feb 29, 5:26*pm, "Ron Coderre"
wrote: Try this: =TEXT(A1,"M/D/YYYY")&B1 Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "kingkhan" wrote in message ... A1=2/29/08,B1=ABC.=A1&B1.resulting in 39507abcab.how to get o/p as 2/29/2008abc in excel- Hide quoted text - - Show quoted text - THANKS IT WORKED OUT :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct not returning expected results | Excel Worksheet Functions | |||
| FILTER applied to many coloumns | Excel Discussion (Misc queries) | |||
| How do I perform bitwise logical anding and oring in Excel? | Excel Worksheet Functions | |||
| Text to Coloumns, by consecutive capital letters | Excel Worksheet Functions | |||
| Expected end of Statement | Excel Worksheet Functions | |||
Linear Mode
