Posted to microsoft.public.excel.misc

jezzica85

Posts: n/a

Combining formulas

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!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combining 2 Formulas	carl	Excel Worksheet Functions	2	February 2nd 06 06:21 PM
Array Formulas take waaaay too long...	belly0fdesire	Excel Worksheet Functions	7	August 8th 05 10:11 PM
Combining two formulas	Redsmartie	Excel Worksheet Functions	2	April 7th 05 09:52 AM
Combining formulas and results HELP!!	JRH	New Users to Excel	4	January 22nd 05 05:26 PM
combining countif formulas	Liz G	Excel Worksheet Functions	3	November 1st 04 09:34 PM

All times are GMT +1. The time now is 08:31 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us