[TheNewGirl]

I don't know about 2010 I only have 2007,

Wetordy, I tried a variation of that with data in a column then I fed it into a new one that went =left(A1,5) for example which will pull the first 5 characters of cell A1, is there a way to tag text onto the end of it? I tried adding "..." but that won't do it and going into the help sets me into a treaty on left to right justification of language. :P

Ferra > You will not be able to do it on Word count. If there's away to do it at all it'd be through character count which you could base on a variable in a second box so you only have to change it in one place and it'll change them all. Still it's more static then you want.