Hello,
I have 7000 rows of data that looks like this
Peter Chisholm
Tanguido Inc.
270 Park Ave.
Yonkers, NY 10703
(914) 378-4290
Nick Chiumento
Colosseum Nightclub
120 Adams Ave
Scranton, PA 18503
(570)357-3423
Danny Choudry
SNS Staging Inc
26 Penn Street
Fords, NJ 08863
(732)744-0600
To Kool Chris
Dance Factory FM/WKIE
16912 Deerpath Drive
Homer Glen, IL 60491
DJ 2 Cool C Chris Dibello
Rane Corporation
10802 47th Avenue West
Mukilteo.WA 98295
(425)355-6000
I need to insert an empty row after each Phone number so it looks like this
Elisa Burg
Popular Party DJ's
Po Box 127
Succasunna, NJ 07876
(973) 361-6262
Charlene Burg
Popular Party DJ's
Po Box 127
Succasunna, NJ 07876
(973)361-6262
Mark Burgess
NAME. Inc.
PO Box 144
Willowgrove, PA 19090
(215)658-1193
CaitJin Burghoffer
Party King Entertainment
30 Sherwood Lane, Ste. #2
Fairfield, NJ 07004
(973)575-5511
Dennis Burke
Magnetic Sound
POB 5984
Philadelphia, FA 19137
(215)743-9049
Robert burke
Bob Burke DJ's
350 S. Old Middletown
Media, PA 19063
(610) 566-6992
Can some one help me write a Macro to insert empty row after phone number?
