Our new Indie Games subforum is now open for business in G&T. Go and check it out, you might land a code for a free game. If you're developing an indie game and want to post about it, follow these directions. If you don't, he'll break your legs! Hahaha! Seriously though.
Our rules have been updated and given their own forum. Go and look at them! They are nice, and there may be new ones that you didn't know about! Hooray for rules! Hooray for The System! Hooray for Conforming!
So I'm wondering if someone knows how to form an Excel macro that will insert a specific character combination (#n) after a certain number of letters (43) in a cell. The catch is, it can't dissect a word that's already there, so if character 43 isn't a space it has to backtrack to find the nearest space.
Basically, the #n is creating a carriage return in the text, dividing it into 3 separate lines (for a Japanese game programmer, I dunno if that's common). I can go through ~20k lines and do it myself, but it's gonna take balls long, and I was hoping there might be a faster way. Any help at all would be appreciated.