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

[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 (e-mail address removed)

Thank you for your help.
Jojn

 

[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

 

[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