I'd like to insert a line break into or replace a certain amount of spaces. I've tried using find & replace and did a couple searches that referenced char(10) as line break but it didn't work. I also tried finding char(9) for tabs but I doubt they make it through excels text import process.

q.1.
I need a macro for replacing for every 10 blank spaces and put a line break in the cells of a whole column or selection in excel?


---====---=-=-=-=-=-=-=----AND


I found this vba for removing spaces in a cell
Public Sub RemoveSpaces()
Application.ActiveCell = Trim(Application.ActiveCell)
End Sub

q.2.
How can I make it trim for a whole column or selection?
[FONT=verdana,geneva,lucida,'lucida grande',arial,helvetica,sans-serif]

Yes I am new to all this and fiddled a bit to actually get the vb editor up, I appreciate the help.[/font]

If you want to iterate the ranges

Public Sub RemoveSpaces_Loop()

For Each oCell in Range("A1:B5").cells
oCell .Value = Trim(oCell .Value)
Next oCell
End Sub

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)