| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
concatenate function help
i have two columns, lets say
column b c d any row blank deposit date 09/12/06 how can i concatenate these two columns so that they will appear in column b as "deposit date 09/12/06". I try using the concatenate function but it brings "deposit date38972", i would like to have a space between "deposit date" and 09/12/06 and not show me the date number 38972, i want it exactly as 09/12/06. thanks for your help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
concatenate function help
Try this.
=c1&" "&text(d1,"mm/dd/yy") andresg1975 wrote: i have two columns, lets say column b c d any row blank deposit date 09/12/06 how can i concatenate these two columns so that they will appear in column b as "deposit date 09/12/06". I try using the concatenate function but it brings "deposit date38972", i would like to have a space between "deposit date" and 09/12/06 and not show me the date number 38972, i want it exactly as 09/12/06. thanks for your help |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
concatenate function help
thanks a lot for your help
"willwonka" wrote: Try this. =c1&" "&text(d1,"mm/dd/yy") andresg1975 wrote: i have two columns, lets say column b c d any row blank deposit date 09/12/06 how can i concatenate these two columns so that they will appear in column b as "deposit date 09/12/06". I try using the concatenate function but it brings "deposit date38972", i would like to have a space between "deposit date" and 09/12/06 and not show me the date number 38972, i want it exactly as 09/12/06. thanks for your help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use formatting from source cell in CONCATENATE function | Excel Worksheet Functions | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| MS Excel "Concatenate" function | Excel Discussion (Misc queries) | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Linear Mode
