| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
removing " marks from imported email addresses
Thanks for the help guys. Appreciate it.
"RichardSchollar" wrote: Hi Have you tried doing a Find/Replace on the email addresses? 1. Select the email address range eg columns A:A 2. Go EditReplace and Find What: ' Replace With: (leave Replace With blank) 3. Hit OK Hope this helps! Richard On 7 Feb, 15:06, Outbacker wrote: how do i remove the ' before and after the email addresses (text) i imported. for example, it looks like this ' . i want it to look like this i have a large column i need to do this for. thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
| make XL stop interpreting email addresses as highlighted links? | Excel Discussion (Misc queries) | |||
| Using CONCATENATE function to create email addresses from a list | Excel Worksheet Functions | |||
| Convert entire columns of text email addresses to hyperlinks | Excel Worksheet Functions | |||
| How do I format email addresses as Text only? | Excel Worksheet Functions | |||
Threaded Mode
