| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Replace a ; with a , and a space
Hi
I have a distribution list that has been pasted into a cell in Excel. The email address are separated by a semi colon. Is there a way to globally replace the semi colon with a comma (,) and a space? eg , etc Hope you can help!! Thanks in advance Jo |
|
#2
|
|||
|
|||
|
Yes. Replace is Ctrl+H. Don't type the "quotes" below.
Find: ";" Replace with: ", " HTH. SpudHutton "Jo" wrote: Hi I have a distribution list that has been pasted into a cell in Excel. The email address are separated by a semi colon. Is there a way to globally replace the semi colon with a comma (,) and a space? eg , etc Hope you can help!! Thanks in advance Jo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace Number with Text using Macro | Excel Discussion (Misc queries) | |||
| Find and Replace - Quickest Option? | Excel Worksheet Functions | |||
| space between text strings with concatenate | Excel Discussion (Misc queries) | |||
| Word: replace ... ... with space | Excel Discussion (Misc queries) | |||
| VB Find and Replace | Excel Worksheet Functions | |||
Linear Mode
