Can 3810 and 3819 and 3806 be joined into one cell

P

pano

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
 
P

pano

=CONCATENATE(A1,"-",A2,"-",A3,"-",A4,"-"A5)





- Show quoted text -
Click to expand...

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
 
Top