View Single Post
 
Old 06-17-2013, 11:13 PM
fzuazua fzuazua is offline Windows XP Office 2003
Novice
 
Join Date: Jun 2013
Posts: 2
fzuazua is on a distinguished road
Default

Activate or click on the cell that has the string and run this macro it will put the spaced string in the next cell down. Assume its on Sheet1

Sub SpaceText ()
With Selection
Zrow = .Row + 1
Zcol = .Column
End With
With Worksheets("Sheet1")
.Cells(Zrow, Zcol) = ""
For I = 1 To Len(Selection.Text)
.Cells(Zrow, Zcol) = .Cells(Zrow, Zcol) & Mid(Selection.Text, I, 1) & " "
Next
End With
End sub
Reply With Quote