Another way:
=left(a1&rept(" ",30),30) & left(b1&rept(" ",30),30) & left(c1&rept(" ",30),30)

If you ever have numbers that need to be formatted nicely (dates, times,
money??), you could use:

=left(text(a1,"$#,##0.00")&rept(" ",30),30) & ...



Mr_Wilf wrote:

Hi,

I need to concatenate three seperate Text fields in to one long string, but
keeping each value to 30 char.

eg
A1 "999 Letsbe Avenue"
B1 "Little Doing Quickly"
C1 "Abyssinia"

into "999 Letsbe Avenue Little Doing Quickly Abyssinia
"
instead of "999 Letsbe AvenueLittle Doing QuicklyAbyssinia" which is what
I'm getting.

Any suggestions?

--

Dave Peterson