replace this Å“ character with pound sign in excel
When copying from Outlook Calendar to Excel worksheet this character Å“
replaces the £ sign on the excel worksheet, it is not in any of the character map options and cannot replace it on the find and replace options because i cannot copy and paste the œ onto the find box to replace every other character copies ok to excel.. |
replace this o character with pound sign in excel
Hi,
You can use the unicode characters in Find/Replace. Find what: alt+0156 (=o) Replace with: alt+0163 (=£) To use unicode hold down the Alt key and press the numbers on the number pad then release the Alt key. You can't use the numbers at the top of your keypad. HTH Martin |
replace this œ character with pound sign in excel
Œ chanracter is ascii 0156 and found in the Character Map under many different
font types. EditReplace What: Alt + 0156 With: Alt + 0163 Note: you must hold the Alt key and enter the numbers using the NumPad. Replace all. Gord Dibben MS Excel MVP On Fri, 6 Apr 2007 00:16:01 -0700, r1947 wrote: When copying from Outlook Calendar to Excel worksheet this character œ replaces the £ sign on the excel worksheet, it is not in any of the character map options and cannot replace it on the find and replace options because i cannot copy and paste the œ onto the find box to replace every other character copies ok to excel.. |
replace this o character with pound sign in excel
Thank You Martin this works great many thanks again.....
"MartinW" wrote: Hi, You can use the unicode characters in Find/Replace. Find what: alt+0156 (=o) Replace with: alt+0163 (=£) To use unicode hold down the Alt key and press the numbers on the number pad then release the Alt key. You can't use the numbers at the top of your keypad. HTH Martin |
replace this Å“ character with pound sign in excel
Thank You Gord Dibben this works great many thanks again.....
"Gord Dibben" wrote: Œ chanracter is ascii 0156 and found in the Character Map under many different font types. EditReplace What: Alt + 0156 With: Alt + 0163 Note: you must hold the Alt key and enter the numbers using the NumPad. Replace all. Gord Dibben MS Excel MVP On Fri, 6 Apr 2007 00:16:01 -0700, r1947 wrote: When copying from Outlook Calendar to Excel worksheet this character œ replaces the £ sign on the excel worksheet, it is not in any of the character map options and cannot replace it on the find and replace options because i cannot copy and paste the œ onto the find box to replace every other character copies ok to excel.. |
All times are GMT +1. The time now is 05:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com