How to delete everything under the name

Closed
quita210 - 10 Jun 2011 à 16:04
GM Madman Posts 83 Registration date Friday 10 June 2011 Status Member Last seen 28 April 2012 - 10 Jun 2011 à 16:12
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

GM Madman Posts 83 Registration date Friday 10 June 2011 Status Member Last seen 28 April 2012 2
10 Jun 2011 à 16:12
Hi,

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

Many regards!