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

  • Thread starter Thread starter GrandpaJohn1
  • Start date Start date
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 (e-mail address removed)

Thank you for your help.
Jojn
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I click on a telephone number in an Excel 2002 spreadsheet, and have the number dialed? 2
Excel Naming columns in excel worksheet 1
Looking up Telephone Numbers 3
converting telephone numbers to csv format! 3
Extracting part of data 4
format cell with multiple formats for telephone numbers 1
Word to Excel: Export comments with text and line number 0
Printing two columns of data in telephone directory style 2

Back
Top