Function SpliText in a macro

**Jokacave** · 03-31-2009, 06:13 AM

Two months ago, DonkeyOte help me (http://www.excelforum.com/excel-prog...e-formula.html) solve a problem, with this function:

Please Login or Register  to view this content.

At that moment, everything works perfect because what I want is transform code numbers like this one
0101010100
into this
01-01-01-01-00
but suddenly start having different kind of code numbers like those
5010301 ( ....which I want transform in this....: 05-01-03-01 )
101050100 ( ....which I want transform in this....: 01-01-05-01-00 )
0101010100 ( ....which I want transform in this....: 01-01-01-01-00 )
02-02-04-00 ( ....which I want transform in this....: 02-02-04-00 )
01.10.01.05.00 ( ....which I want transform in this....: 01-10-01-05-00 )

Can somebody help me.
Thanks in advance

I attached the files which I.m using
*I open the "testnew1" with the "Action"

**DonkeyOte** · 03-31-2009, 07:03 AM

Perhaps you could adapt slightly...

Please Login or Register  to view this content.

No change to the call made from the cell just some additional code in the Function itself... for strings containing uneven number of chars it is assumed a leading zero is required (eg 11112 should be 011112 - ie to become 01-11-12)

**Jokacave** · 03-31-2009, 08:05 AM

DonkeyOte,

That worked perfectly well.
By the way, do you know any addresses in the WWW where I can get any information about Functions?

Thank you very much... once again.

**zplugger** · 03-31-2009, 08:40 AM

Good Morning, their is so much cool stuff on this site. How was the button made in the Action.xls file. I see it was a Auto shape item but being new too excel not sure how it works. If I not suppose too ask about it in this thread I sorry,I can ask in my own thread. I love reading and looking at all the projects here. There are so many smart people here. Even a old guy like me can learn new things. Just starting learning excel about a month ago, I have learned a lot from this great site.
Thanks

**Jokacave** · 03-31-2009, 09:07 AM

Hi,
I.m not sure too if I can answer your question but...
Yes, it is a AutoShape and with the mouse´s right-click I assign the macro XX, and yes, this is the right place to "old guys" like us learn about Excel.

**DonkeyOte** · 03-31-2009, 09:11 AM

You can also make use of the ActiveX controls (rather than Forms controls) as these can be easier to work with - each ActiveX Control (button,checkbox etc) have their own specific event handlers