ASAP Utilities, a free Add-in available from
www.asap-utilities.com has a
feature that will remove all alpha characters from the selection...........
Vaya con Dios,
Chuck, CABGx3
"Kim" wrote in message
...
Column "A" has a few variations eg:
90,000 K
190,000 Klm Ser
Service 190,000 Klm
I want to remove all characters from each cell to leave in the adjacent
cell
the following
90,000
190,000
190,000
I've done find and replace and recorded a macro but I need to update the
sheet each day and want it to be more automatic. The sheet has around
15000
rows so it takes a while to remove all variations manually, each time it's
updated.
I'd appreciate any help
Thanks