+ Reply to Thread
Results 1 to 2 of 2

Where do i add this

  1. #1
    facebuddies
    Guest

    Where do i add this

    Hi

    Can someone please help me as to how and where i should load this code (Is it a macro?)

    Sub split_at_spaces()
    Do While ActiveCell.Value <> Empty
    If InStr(ActiveCell.Value, " ") <> 0 Then
    ActiveCell.Offset(1, 0).Value = _
    Right(ActiveCell.Value, Len(ActiveCell.Value) - _
    InStr(ActiveCell.Value, " "))
    ActiveCell.Value = Left(ActiveCell.Value, _
    InStr(ActiveCell.Value, " "))
    End If
    ActiveCell.Offset(1, 0).Select



    Thanks Guys

    :-)

  2. #2
    facebuddies
    Guest
    Hurray i worked it out in the end! Got a headache now lol

    :-)

+ 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