manipulating a column

[Kelly_Golden]

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?

 

[JE McGimpsey]

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?

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.