How to delete everything under the name

Closed
Report
-
Posts
85
Registration date
Friday June 10, 2011
Status
Member
Last seen
April 28, 2012
-
Hello,
I'm trying to make labels in excel I know how to transfer it to word to make them. My problem is I need the name on the top and everthing under the name needs to be deleted, how do I do it? Its all in One row and I have multiple of them I need to keep, ace bolt & screw company and 200 brooklyn ave needs to be deleted how do I do it if its in one row just the way you see it at the bottom. Is there a formula to do this? Please help me.

Ace Bolt & Screw Company
200 Brooklyn Ave.
San Antonio, TX 78215-1826
United States


1 reply

Posts
85
Registration date
Friday June 10, 2011
Status
Member
Last seen
April 28, 2012
2
Hi,

You just need to press"Enter to put them in separate lines and to erase you just push"Backspace"

Many regards!