Insert Empty Row after Phone #

Closed
c-Russ - Sep 30, 2009 at 09:33 AM
 Blocked Profile - Sep 30, 2009 at 05:04 PM
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?

Thanks,

1 reply

Blocked Profile
Sep 30, 2009 at 05:04 PM
Very simple you click on the number of the row just below and right click and click on insert !
-13