On Fri, 24 Mar 2006 08:41:33 -0600, Max_power
wrote:


I'm sorry I see where it is now that I'm going wrong. Two of the columns
that I'm concatenating are text columns. The first formula works perfect
with one text and one integer. Can I make excel read one of the text
columns as an integer?

Thanks


On my worksheet, the formula works whether the second column is a number
formatted as a number, or a number formatted as text.

Try this formula instead:

=CONCATENATE(A1,REPT(" ",22-LEN(A1)-LEN(B1)),B1)

1. Change the 22 to whatever is necessary so that it is greater than the
maximum sum of the lengths of strings in A1 & B1).

2. USE a fixed pitch font (e.g. Courier, or Courier New, or Lucida Sans
Typewriter or ...


--ron