Search : in
By :

Insert Empty Row after Phone #

Last answer on Sep 30, 2009 10:04:43 pm BST c-Russ, on Sep 30, 2009 2:33:33 pm BST 
 Report this message to moderators

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,

Configuration: Windows Vista Internet Explorer 8.0

Best answers for « Insert Empty Row after Phone # » in :
Inserting text in a file ShowInserting text in a file Introduction Syntax Introduction It is sometimes useful to insert text in the header of one or more document (s) or in a specific part of the document (before or after a specific line). The publisher of...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL + ; in the chosen cell. To insert current time, press CTRL+...
Inserting animated gif ShowInserting animated gif An animated gift can be inserted in a powerpoint show like any other graphical format ( e.g bmp, jpg, etc) To enable this: Add a new slide that can contain an image. Select the option “Insert...
Download Active Phone Server ShowDescription The application is designed by SoftCab, Inc. So far this application is well known worldwide for its perfection. It has won awards in certain places and it is being used by companies also. Active Phone Server is an application based on...
Download 3CX VOIP Phone for Windows Show
Download USA Unlisted Cell Phone Numbers ShowHas you friend flown for America without telling you where he/she would settle? Dont panic! USA Unlisted Cell Phone Numbers is a program which can help you. By using this program, you simply need to know his/her phone number in order to find...
PC assembly - Inserting memory modules ShowInserting RAM modules There are various types of random access memory. The latest motherboards are equipped with DDR2 or DDR memory. Some are even equipped with RAMBus memory. The oldest ones actually have SDRAM connectors, or even EDO RAM...
Ask your question Reply

1

 mysticdreams, on Sep 30, 2009 10:04:43 pm BST

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

   
Reply to mysticdreams
Ask your question Reply
They need your help