cleaning excel columns

I don't think it can be done but by jove its worth asking!

I have one column in an excel worksheet filled with names and these names have numbers attached to them. The numbers are at the back and sometimes in the front. They are multi digit and all different. I want the names by themselves! Trying to convert Text to columns doesn't work in helping me as the numbers are all over the place.

Is there anyway of removing the numbers?

Jo

Does this work?

Please Login or Register  to view this content.