Thanks for your reply, John.

I'm afraid that I'm not fluent enough in excel to make sense of what
you've posted. Perhaps if I back up a step to the point where my data
were in numeric form it would be easier (they weren't entered as
text).

I have two tables: one that calculates the the mean percent, and one
that calucaltes the standard error. I then made a table that
concatenates the two and inserts the +/- symbol between them. I copy
and paste this into a clean space and that's my final product. It looks
like this where B53 is the % and L53 is the std error:

=IF(B530,CONCATENATE(FIXED(B53,1)," ± ",FIXED(L53,1),"%"),FIXED(0,0))

is there an easy way to line them up from this starting point?


--
guillemot
------------------------------------------------------------------------
guillemot's Profile: http://www.excelforum.com/member.php...o&userid=29833
View this thread: http://www.excelforum.com/showthread...hreadid=501818