Editing list of properties

[kangen333]

Hello,

I was wondering, is it possible to edit text after a certain set of characters in an entire list at once?

For example,

Say I have a list of 1000 rows including business addresses that ends with "- potential customers 1" in the same cell, so for example, "Main Street 222 - potential customers 1". But I wanted
to edit the entire list of cells so they all show "- leads list 1", so for example "Main Street 222 - leads list 1", would there be a function in excel that would allow all of the fields to be edited at once after the hyphen?

If so, this would literally save me hours upon hours worth of time.


And also, I had another question. I have another row that has a list of business' email and website separated with a | , I'm not sure what it's called. But all of the cells sort of look like "[email protected]|www.businesswebsite.com". Would there be a function in excel that could separate and move the website to the right column?

All help would be greatly appreciated,

Thank you for your time!
Shawn.

[kangen333]

Sorry when I said " I have another row that has a list of business' email and website" I meant to mention that I have another column.

Thanks

[TMS]

For the first part of the question, you can use Edit | Replace | "- potential customers 1" | "- leads list 1" | Replace all. Make sure you don't tick the whole cell option.

For the second part, you can use Text to Columns with the Pipe (|) as the delimiter.

Regards, TMS