MrExcel Publishing
Your One Stop for Excel Tips & Solutions

cutting text out of a list of ceels with combined text and numbers

Posted by Dominic on August 17, 2001 2:00 AM

I have a download from SAP where the customer number and name is included in the same column/cell. I want to split this up so that I only have the numbers in one column and the names in another

At present I manually cut and paste, But for a list of 200 customers it is tiresome, How can I automate this task

Posted by Aladin Akyurek on August 17, 2001 2:40 AM

Have a look at Data|Text To Columns, or use a formula-based solution.

If you want the latter, post a few examples from your SAP download.