| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can 3810 and 3819 and 3806 be joined into one cell
Hi all,
Is it possible to do this, have them show up in one cell with a - between them or a seperator?? A1 3810 3819 3810FL 3806 3818 so in B2 this is the result 3810-3819-3810FL-3806-3808 thanks Stephen |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can 3810 and 3819 and 3806 be joined into one cell
Hi Stephen,
Try: =A1&"-"&A2&"-"&A3&"-"&A4&"-"&A5 Good luck! On Feb 6, 6:04 pm, "pano" wrote: Hi all, Is it possible to do this, have them show up in one cell with a - between them or a seperator?? A1 3810 3819 3810FL 3806 3818 so in B2 this is the result 3810-3819-3810FL-3806-3808 thanks Stephen |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can 3810 and 3819 and 3806 be joined into one cell
=CONCATENATE(A1,"-",A2,"-",A3,"-",A4,"-"A5)
"pano" wrote: Hi all, Is it possible to do this, have them show up in one cell with a - between them or a seperator?? A1 3810 3819 3810FL 3806 3818 so in B2 this is the result 3810-3819-3810FL-3806-3808 thanks Stephen |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can 3810 and 3819 and 3806 be joined into one cell
On Feb 7, 10:17 am, Teethless mama
wrote: =CONCATENATE(A1,"-",A2,"-",A3,"-",A4,"-"A5) "pano" wrote: Hi all, Is it possible to do this, have them show up in one cell with a - between them or a seperator?? A1 3810 3819 3810FL 3806 3818 so in B2 this is the result 3810-3819-3810FL-3806-3808 thanks Stephen- Hide quoted text - - Show quoted text - Thanks for putting me on the right track of what this was called I found this in the archives and it works for what I need as there are empty cells that need to be left out. =SUBSTITUTE(TRIM(A1&" "&B1&" "&C1&" "&D1&" "&E1)," ",", ") Thanks once again |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
