Removing text in excel

[jpurkiss]

Hi

I have a number of names and codes combined in excel, that I want to show in another column as the name only, there a formula that can do this eg:

Amanda NewmanAN5 becomes Amanda Newman
Simon SmithSS1 becomes Simon Smith
David JamesDJ2 becomes David James

Thanks in advance

 

[VoG]

If the codes are always 3 characters

=LEFT(A1,LEN(A1)-3)

 

[hiker95]

jpurkiss,

How about something like this?

Excel 2007
	A	B
1	Amanda NewmanAN5	Amanda Newman
2	Simon SmithSS1	Simon Smith
3	David JamesDJ2	David James
4
Sheet1

Cell Formulas
Range	Formula
B1	=LEFT(A1,LEN(A1)-3)

The formula in cell B1 copied down:
=LEFT(A1,LEN(A1)-3)