Previous Topic Next Topic

How to delete everything under the name

Closed
quita210 - Jun 10, 2011 at 04:04 PM
GM Madman Posts 85 Registration date Friday June 10, 2011 Status Member Last seen April 28, 2012 - Jun 10, 2011 at 04:12 PM
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 response

Answer 1 / 1
GM Madman Posts 85 Registration date Friday June 10, 2011 Status Member Last seen April 28, 2012 2
Jun 10, 2011 at 04:12 PM
Hi,

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

Many regards!
0