excel cutting surname from name column pasting into new column

V

vickie hull

I am taking an on-line training in Microsoft Office. One of the practice
sessions is Working with a data file and fields. The program I am working in
is Excel. I need to know how (very simply put) to cut an existing surname in
a column and paste it into the next column. I can't seem to highlight it and
can't get there by editing it. Please help.
 
G

Gord Dibben

Vickie

Try Data>Text to Columns with space-delimited.

You can also cut it from the string in the Formula Bar when in Edit mode.

Hang in, there will be others with more methods.

Gord Dibben Excel MVP

On Wed, 6 Oct 2004 14:33:02 -0700, "vickie hull" <vickie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
VBA - exporting serial letters to single documents 0
Copying Rows with values in column A pasting in a new doccument and saving that doc 1
cannot paste source column width to destination column width 1
Cut and "insert cut cells" in Excel 2007 doesn't work. 11
Structures 0
Prevent rows wrapping over multiple columns in a report 1
Finding the height of a row in a word table from Excel 0

Top