I need a formula the will modify each cell in a column by inserting a space in front of each upper case letter. Example "HighMotorCurrentOverload" needs to be "High Motor Current Overload"
I need a formula the will modify each cell in a column by inserting a space in front of each upper case letter. Example "HighMotorCurrentOverload" needs to be "High Motor Current Overload"
Welcome to the board. Let me know if this UDF works for you. I have also included instructions below on how to install the function.
===============Please Login or Register to view this content.
How to install the User Defined Function:
1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save as a macro-enabled workbook
The function is installed and ready to use.
Last edited by Al Chara; 09-05-2012 at 09:18 PM.
http://www.mrspreadsheets.com
Al Chara,
I have your function installed as you described. It is working good well.
Thank You...
Last edited by excelrod; 09-06-2012 at 11:31 AM.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
It works for me. How did you try using it?
HTH
Regards, Jeff
Jeff,
The truth is that I jumped the gun.. It is working well.
No worries just glad you have what you need.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks