i have a long list, which i imported from other data base.
The problem is:
1. In each cell, besides data (data is in alphabates) there are som
numeric characters which i dont want .
How can i get rid of all those unwanted numbers from data, from all th
list?

2. The data is in every second row, ie. one row is empty.
How can i Delete those empty/blank rows from the list

--
Message posted from http://www.ExcelForum.com