Never mind, I was proactive and actually did it! I think that formula you
put up got me on the right track. Thanks again so much!

"jezzica85" wrote:

Hi all,
I have 2 formulas:
=IF(LEFT(A1,1)="#",UPPER(MID(A1,1,2)),LOWER(MID(A1 ,1,2)))&LOWER(MID(A1,3,LEN(A1)))
and
=IF(LEFT(C1)="%",UPPER(C1),C1)

As it is right now, I have to format a column of data using the top formula
first, then reformat the data with the second formula once the first set is
copied to the C column. Is there any way to combine these formulas so I can
do them both in one step? Thanks!