Will REPLACE Do This?

User avatar
BobH
UraniumLounger
Posts: 9218
Joined: 13 Feb 2010, 01:27
Location: Deep in the Heart of Texas

Will REPLACE Do This?

Post by BobH »

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?

:cheers: :chocciebar: :thankyou:
Bob's yer Uncle
(1/2)(1+√5)
Intel Core i5, 3570K, 3.40 GHz, 16 GB RAM, ECS Z77 H2-A3 Mobo, Windows 10 >HPE 64-bit, MS Office 2016

User avatar
BobH
UraniumLounger
Posts: 9218
Joined: 13 Feb 2010, 01:27
Location: Deep in the Heart of Texas

Re: Will REPLACE Do This?

Post by BobH »

[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.
Bob's yer Uncle
(1/2)(1+√5)
Intel Core i5, 3570K, 3.40 GHz, 16 GB RAM, ECS Z77 H2-A3 Mobo, Windows 10 >HPE 64-bit, MS Office 2016

User avatar
HansV
Administrator
Posts: 78237
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Will REPLACE Do This?

Post by HansV »

It's fine if you post a solution to your own problem! :thumbup:

See Replacing special characters for a list of available codes.
Best wishes,
Hans