Surname list, to take out the first initial. | Excel forum

Resolved · Low Priority · Version 2010

Mon 9 Dec 2013, 16:47 Delegate Lena said...

Lena has attended:
Excel Intermediate course

Surname list, to take out the first initial.

On the course we were shown how to split a cell that had the first initial with the surname but unfortunately I have forgot. Could you please refresh my mind, Many thanks

Tue 10 Dec 2013, 16:36 Trainer Gary said...

RE: Surname list, to take out the first initial.

Hi Lena

Thanks for getting in touch. You can split cells with the Text to Columns feature.

Highlight your list of names, go to Data and press Text to Columns. You will be asked whether to split cells based on a character ("delimited ") or at certain positions (" fixed width"). Then follow the wizard through.

Try this out and let us know how you get on.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Tue 17 Dec 2013: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Using Alt in Save Dialog Box

When you are saving (or opening) a file, try these;
(Note the numbers are on the keyboard not the numeric keypad)
1. Go to previous folder Alt+1
2. Go up one folder level Alt+2
3. Search the Web Alt+3
4. Delete selected file Alt+4 or Delete
5. Create a new folder Alt+5
6. Cycle through all views Alt+6 repeatedly
7. Display the Tools menu Alt+7

View all Excel hints and tips