ST Alpha - "There are lots of ways. Do you know that it will always start with 0 and there will be no other 0 before it?" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 155

In response to "Excel help! This one I think is tricky" by Jovian

There are lots of ways. Do you know that it will always start with 0 and there will be no other 0 before it?

Posted by oblique [220] (aka kkuphal) Jan 25 '13, 12:53

You can search out the position of the first 0 and the substring from that to the next - for example

Responses:

Post a message top