 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / March 2008manipulating a column
Version: 2004 I have a column with 3 pieces of data in it. I want to delete the first and second pieces. Any suggestions? ex. 1234AGolden (the 1234 is the person's #, the A indicates he is active, Golden is the last name). I want to leave just the last name in the column. How do I delete the 1234 and A? > Version: 2004 > [quoted text clipped - 4 lines] > Golden is the last name). I want to leave just the last name in the column. > How do I delete the 1234 and A? If the "person's #" is always 4 digits and the status is always one character: =MID(A1,6,256) where 256 is just a number large enough to capture the entire last name. If those two things are true, you could also do it in-place with Data/Text to Columns: Choose Fixed width in the First Pane, click Next, click between the "A" and "G" to insert a break line, click Next, then select the "Do not import column (Skip)", click Finish. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.