Can there be anything else than # or % as the first character in A1?
Can you give an example of the string in A1?

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"jezzica85" wrote in message
...
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!