HOW DO I INSERT 1 SPACE BEFORE A TELEPHONE NUMBER IN EXCEL SPREAD

G

GrandpaJohn1

I would like to use a macro to insert 1 space before a list of telephone
numbers in Excel. I have one macro that works but when I reuse it on the next
10 numbers it copies the numbers from the first group.

Please respond to [email protected]

Thank you for your help.
Jojn
 
M

Mike H

Hi,

It would have helped if you had posted you macro, does this one do what you
want

Sub addspace()
For Each c In Selection
With c
.NumberFormat = "@"
.Value = " " & c.Value
End With
Next
End Sub

Mike
 
G

GrandpaJohn1

Thank you Mike for your help.
As for my macro all I was doing is RECORD A NEW MACRO following my keyboard
entries. This is my first attempt at a macro.
I will attempt to work with what you sent.

John
 
Top