Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 06-17-2013, 11:13 PM
fzuazua fzuazua is offline Excel 2007 cell format help!!! Windows XP Excel 2007 cell format help!!! 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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 cell format help!!! Format Excel to look like Word Kilconey Excel 1 04-30-2010 09:42 AM
Splitting Excel cell into multiple ruben23 Excel 1 07-23-2009 03:49 AM
Auto-populate an MS Word table cell with text from a diff cell? dreamrthts Word Tables 0 03-20-2009 01:49 PM
Excel error: "Too many different cell formats" enviroko Excel 0 01-09-2008 07:27 AM
Excel 2007 cell format help!!! paste formated text from Word to only one Excel cell heron Word 1 12-06-2005 02:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:33 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft