How to do the OPPOSITE from the function PROPER

vi3tboiz15 vi3tboiz15 is offline

New Member

Join Date: Aug 2011

Posts: 1

3rd Aug 2011

I need help!!! I want to do do the completely opposite of the function PROPER

A1 = HI MY NAME IS TOM

=PROPER(A1) --> Hi My Name Is Tom

I need a function that can Inverse this into --> hI mY nAME iS tOM

« Can I sort or filter or delete by strike-through? | Excel Macro »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What is the function opposite of LOG	=?Utf-8?B?ZXJpaw==?=	Microsoft Excel Worksheet Functions	3	28th Jan 2006 08:52 AM
What is the function opposite of LOG	=?Utf-8?B?ZXJpaw==?=	Microsoft Excel Worksheet Functions	0	27th Jan 2006 03:41 AM
What function is the opposite of SUM?	=?Utf-8?B?cnNpbHZlcg==?=	Microsoft Excel Misc	4	19th Nov 2005 06:56 PM
Opposite of SUM function is ??	=?Utf-8?B?YW1rYXplbg==?=	Microsoft Excel Misc	1	18th Apr 2005 07:13 PM
The opposite of IF function gives #VALUE for value = 0	gizmo	Microsoft Excel Worksheet Functions	2	30th Dec 2004 01:36 PM