Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Does each cell have one word or more than one? In other words, how
many spaces do you want to insert? If only one word in a cell, then: Sub macro1() Dim rng As Range Dim c As Range Set rng = Sheets("Sheet1").Range("A1:A6") For Each c In rng c = Left(c, 3) & " " & Right(c, Len(c) - 3) Next c End Sub Hth, Merjet |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I change the y-axis on an Excel chart from numbers to words | Charts and Charting in Excel | |||
How do I change automatically figures into words in Excel | Excel Worksheet Functions | |||
How can we change linked numbers to words in Excel? | Excel Programming | |||
In Excel, how do I change Column Hdings to words not A, B? | Excel Programming | |||
How can I change Numbers in WOrds in Excel | Excel Discussion (Misc queries) |