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: 9284
- Joined: 13 Feb 2010, 01:27
- Location: Deep in the Heart of Texas
Will REPLACE Do This?
Bob's yer Uncle
Dell Intel Core i5 Laptop, 3570K,1.60 GHz, 8 GB RAM, Windows 11 64-bit, LibreOffice,and other bits and bobs
(1/2)(1+√5) |
-
- UraniumLounger
- Posts: 9284
- 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
Dell Intel Core i5 Laptop, 3570K,1.60 GHz, 8 GB RAM, Windows 11 64-bit, LibreOffice,and other bits and bobs
(1/2)(1+√5) |
-
- Administrator
- Posts: 78478
- 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