Insert Empty Row after Phone #

Closed
Report
-
 Blocked Profile -
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


Very simple you click on the number of the row just below and right click and click on insert !