"Pete Elbert" wrote:
.. However in C1 I have a formula
=A1&","&A2&","&A3&","&A4&""

For an automated neater display, put instead in C1:
=SUBSTITUTE(TRIM(A1&" "&A2&" "&A3&" "&A4)," ",",")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---