Delete the graph based on its character number

puff · #1 02-27-2018, 11:39 PM

Quote:

Originally Posted by macropod

You don't even need a macro for that - just an ordinary Find/Replace. For example, to delete paragraphs containing exactly three characters (in addition to the paragraph break), use:
Find = ^p^?^?^?^p

Replace = ^p
or you could use a wildcard Find/Replace with:
Find = ^13[!^13]{3}^13
Replace = ^p

To delete paragraphs containing up to three characters (in addition to the paragraph break), use a wildcard Find/Replace with:
Find = ^13[!^13]{1,3}^13
Replace = ^p

Thanks! This is very neat! Just a note that the last line should be Replace = ^13

macropod · #2 02-27-2018, 11:40 PM

Quote:

Originally Posted by puff

Just a note that the last line should be Replace = ^13

No, it shouldn't! You will get very strange document behaviour if you do that.

puff · #3 02-28-2018, 12:38 AM

Quote:

Originally Posted by macropod

No, it shouldn't! You will get very strange document behaviour if you do that.

Sorry. Yeah, you're right. I tested it on a piece of manually typed very simple text and I did notice that will cause some change in the format.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
count a number of cells based on the beginning of a order number	Kubi	Excel	2	08-06-2017 08:54 PM
Delete Character on Single Line Only	Tye30	Word VBA	8	04-20-2017 08:40 PM
Delete starting number *) and delete Unneeded data in series	frustrated teacher	Word VBA	5	12-07-2014 06:53 PM
first character NOT Alpha numeric or Tilde (~) delete.	ksridh	Word VBA	5	03-17-2014 12:45 AM
graph changes number when losing embedded link	Alaska1	Excel	0	08-14-2013 11:31 AM