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
You can try to do this manually:
ctrl_H, replace
replace: " ??????*"
by ""
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.