Delete first two characters in a cell...
 

I have a spreadsheet which shows the first inital and a space for
everyone in our company. I am trying to cut that down to simply show
the last name. Can anyone help me delete the first two characters
(first initial and the space) from a spreadsheet like this?

A Smith
A Thomas
B Patterson
C Jones

I want to return the following:
Smith
Thomas
Patterson
Jones

Delete first two characters in a cell...
 

And lose the first two characters?

Select that column
Data|Text to columns
Fixed width
draw a line before the last name
choose not to import the first field
and plop the results into the original location.

ChuckF wrote:

I have a spreadsheet which shows the first inital and a space for
everyone in our company. I am trying to cut that down to simply show
the last name. Can anyone help me delete the first two characters
(first initial and the space) from a spreadsheet like this?

A Smith
A Thomas
B Patterson
C Jones

I want to return the following:
Smith
Thomas
Patterson
Jones

--

Dave Peterson

Delete first two characters in a cell...
 

Try this: =MID(A1,3,255)
If you then want to delete all the names with initials you should first use
Copy followed by Paste Special (Values) on the cell with this formula.
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ChuckF" wrote in message
ups.com...
I have a spreadsheet which shows the first inital and a space for
everyone in our company. I am trying to cut that down to simply show
the last name. Can anyone help me delete the first two characters
(first initial and the space) from a spreadsheet like this?

A Smith
A Thomas
B Patterson
C Jones

I want to return the following:
Smith
Thomas
Patterson
Jones

Delete first two characters in a cell...
 

=RIGHT(A1,LEN(A1)-FIND(" ",A1))

ma ma no teeth

"ChuckF" wrote:

I have a spreadsheet which shows the first inital and a space for
everyone in our company. I am trying to cut that down to simply show
the last name. Can anyone help me delete the first two characters
(first initial and the space) from a spreadsheet like this?

A Smith
A Thomas
B Patterson
C Jones

I want to return the following:
Smith
Thomas
Patterson
Jones

Delete first two characters in a cell...
 

Select the relevant column, then go to Data--Text to columns and follow the
instructions. You'll be able to split the A Smith into two separate columns,
A and Smith. Delete the first column with the first initials if needed.

Dave
--
Brevity is the soul of wit.


"ChuckF" wrote:

I have a spreadsheet which shows the first inital and a space for
everyone in our company. I am trying to cut that down to simply show
the last name. Can anyone help me delete the first two characters
(first initial and the space) from a spreadsheet like this?

A Smith
A Thomas
B Patterson
C Jones

I want to return the following:
Smith
Thomas
Patterson
Jones

Delete first two characters in a cell...
 

Thanks everyone!

Dave F wrote:
Select the relevant column, then go to Data--Text to columns and follow the
instructions. You'll be able to split the A Smith into two separate columns,
A and Smith. Delete the first column with the first initials if needed.

Dave
--
Brevity is the soul of wit.


"ChuckF" wrote:

I have a spreadsheet which shows the first inital and a space for
everyone in our company. I am trying to cut that down to simply show
the last name. Can anyone help me delete the first two characters
(first initial and the space) from a spreadsheet like this?

A Smith
A Thomas
B Patterson
C Jones

I want to return the following:
Smith
Thomas
Patterson
Jones

Delete first two characters in a cell...
 

try something like
=right(A1,len(A1)-2)

"ChuckF" wrote:

I have a spreadsheet which shows the first inital and a space for
everyone in our company. I am trying to cut that down to simply show
the last name. Can anyone help me delete the first two characters
(first initial and the space) from a spreadsheet like this?

A Smith
A Thomas
B Patterson
C Jones

I want to return the following:
Smith
Thomas
Patterson
Jones