PDA

View Full Version : find large numbers and delete



ccruz
02-06-2013, 04:49 AM
hello
I'm looking for a code that when after TWO spaces find numbers with more than 5 digits delete those numbers
is it possible ?

ccruz

parttime_guy
02-12-2013, 07:40 PM
Hi CCruz,

Can you post some sample data with the results required.

You could use a filter - to show figures greater than 10000

If all your data is in the same format, you could the following function
Data > Text to Column > Fixed Width (use the mouse to extract amounts into separate column - and complete ur task)

Regards

snb
02-13-2013, 02:14 AM
You can try to do this manually:

ctrl_H, replace

replace: " ??????*"
by ""