+ Reply to Thread
Results 1 to 2 of 2

space between evey letter

  1. #1
    Registered User
    Join Date
    02-25-2009
    Location
    Leeds, England
    MS-Off Ver
    Excel 2007
    Posts
    43

    space between evey letter

    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

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: space between evey letter

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1