Insert Special characters in a formula using codes?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Everyone,
I am trying to insert special characters into a formula using Unicode..
In Excel, I would use something like so:
Solved! Go to Solution.
- Labels:
- Parse
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thats a tricky one hahaha, i dont know if the replace formula do that
Try to use Regex to do this or create a table with the code/specialcharacters and use the find/replace.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @E4Victory ,
I've attached a tool that allows you to pull tables from HTML. Use this to load in that table, then use a find and replace tool to replace with the unicode characters.
Hope this helps.
M.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @E4Victory
You can try CharFromInt() function which turns Unicode number to character. Using this you can replace. Guessing its similar to Char function.
And vise versa is CharToInt()
Hope this helps 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is a good solution, thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That's perfect. Thank you it worked like charm.
Here is the requested formula: Replace([cell], CharFromInt(160), " ").
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Glad to hear that fixed your issue @E4Victory . Excel Char() was a new function to me 😅
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
