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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.