Hi,
is there a formula to add a space between every word ie
James with forumla should look j a m e s
the file is very big i know you could a letter in each sell but this would save time
Thanks
James
Hi,
is there a formula to add a space between every word ie
James with forumla should look j a m e s
the file is very big i know you could a letter in each sell but this would save time
Thanks
James
You could make use of morefunc.xll REGEX functions... eg
A1: James
B1: =REGEX.SUBSTITUTE(A1,"([a-zA-Z])","[1] ")
B1 becomes J a m e s
You would of course need to download and install morefunc.xll though
http://download.cnet.com/Morefunc/30...-10423159.html
For info on morefunc see:
http://xcell05.free.fr/morefunc/english/
It's an excellent utility ... it can also be embedded into a workbook so does not need to be installed manually on each client like a traditional add-in.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks