I have a long list of words and terms separated by commas and spaces. I cannot find a way to sort them to make finding a specific one easier. I would like to remove the commas and spaces and insert a paragraph mark and new line. I (think) that the list can then be sorted.
Is it possible to use the Replace function as described. If so, how do I tell it to insert a paragraph delimiter and a new line?
If Replace is the wrong choice, how would you go about sorting such a list?
Will REPLACE Do This?
-
- UraniumLounger
- Posts: 9218
- Joined: 13 Feb 2010, 01:27
- Location: Deep in the Heart of Texas
Will REPLACE Do This?
Bob's yer Uncle
Intel Core i5, 3570K, 3.40 GHz, 16 GB RAM, ECS Z77 H2-A3 Mobo, Windows 10 >HPE 64-bit, MS Office 2016
(1/2)(1+√5) |
-
- UraniumLounger
- Posts: 9218
- Joined: 13 Feb 2010, 01:27
- Location: Deep in the Heart of Texas
Re: Will REPLACE Do This?
[Bad form, I know, to reply to one's own post. I do so only because the post and response might someday help others.]
I kept searching and found that the characters ^p used in the Replace With box will insert a paragraph break. A simple comma (,) in the Find box gets all instances.
I kept searching and found that the characters ^p used in the Replace With box will insert a paragraph break. A simple comma (,) in the Find box gets all instances.
Bob's yer Uncle
Intel Core i5, 3570K, 3.40 GHz, 16 GB RAM, ECS Z77 H2-A3 Mobo, Windows 10 >HPE 64-bit, MS Office 2016
(1/2)(1+√5) |
-
- Administrator
- Posts: 78237
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Will REPLACE Do This?
It's fine if you post a solution to your own problem!
See Replacing special characters for a list of available codes.
See Replacing special characters for a list of available codes.
Best wishes,
Hans
Hans