ie are the numbers & text in separate cells, if so you can select the column
and then choose edit / goto special / constants - leave only the numbers box
ticked, choose Ok & then press the delete key on the keyboard
if they're mixed numbers /text, please copy & paste a sample of your data
for us to look at
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.