PDA

View Full Version : Solved: Removing numbers from a text block



mike31z
06-14-2008, 09:24 PM
I have A number of columns that contain from 1 to 3 digits then a persons first name then last Name. Is there an easy way to seperate the numbers from the names. I can find a excel formula that will accomplish this.

Mike in Wisconsin

Bob Phillips
06-15-2008, 01:18 AM
No need for a formula, just use Data>Text To Columns with a delimiter of space.

mike31z
06-15-2008, 03:43 AM
That solved it

Thank You very much

I have used that when importing comma seperated data but never thought of it for a single column to seperate data.