Results 1 to 14 of 14

how is separating the word to character ?

Threaded View

  1. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: how is separating the word to character ?

    Function AddSpace(Str As String) As String
        Dim i As Long
        For i = 1 To Len(Str)
            AddSpace = AddSpace & Mid(Str, i, 1) & " "
        Next i
        AddSpace = Trim(AddSpace)
    End Function
    How to install your new code
    Copy the Excel VBA code
    Select the workbook in which you want to store the Excel VBA code
    Press Alt+F11 to open the Visual Basic Editor
    Choose Insert > Module
    Edit > Paste the macro into the module that appeared
    Close the VBEditor
    Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)


    Then use:

    =AddSpace(A3)
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Add a character before each word in a cell
    By jas225 in forum Excel General
    Replies: 9
    Last Post: 08-07-2018, 01:35 AM
  2. [SOLVED] Removing character(s) from end of last word
    By VegasL in forum Excel General
    Replies: 5
    Last Post: 04-20-2017, 12:23 AM
  3. [SOLVED] extract a word if it contains a particular character
    By emymeeky in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-28-2013, 04:50 PM
  4. Remove text after or before character or word?
    By mikey42979 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-19-2013, 08:47 AM
  5. Remove last word/character from a string
    By Delkath in forum Excel General
    Replies: 3
    Last Post: 09-08-2010, 01:48 PM
  6. Parsing out a word after a character (#)
    By BZabrocki in forum Excel General
    Replies: 1
    Last Post: 06-06-2007, 02:52 PM
  7. Insert a special character before and after a word
    By Venkatesh V in forum Excel General
    Replies: 1
    Last Post: 02-21-2005, 11:06 AM

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