Forum Discussion
sunnyschindler
Jul 25, 2023Brass Contributor
LOOKUP to include formatting with its Return Value? Formatting Code Function? non-VBA request
Without VBA, is it possible for LOOKUP to return formatting of its Return Value? It is much easier if Formatting Code Function (similar to CODE function) can be exposed to end user. I need to di...
peiyezhu
Jul 30, 2023Bronze Contributor
because VBA local window is not showing Unicode for said string.
How about build or edit html page and copy and paste to excel
sunnyschindler
Jul 31, 2023Brass Contributor
Word is capable of what I need by find and replace (1) all emoji with superscript and (2) ASCII alphabets with subscript.
With my limited VBA expertise, I am tempted to record Word macro to do above with input (hyperlinked) from Excel (formula output).
I like to know if anyone can share code that Find and Replace (1) all EMOJI with a fixed formatting (2) all Alphabets with another fixed formatting.
Otherwise, I will spend the time creating a wheel probably someone else already perfected.
With my limited VBA expertise, I am tempted to record Word macro to do above with input (hyperlinked) from Excel (formula output).
I like to know if anyone can share code that Find and Replace (1) all EMOJI with a fixed formatting (2) all Alphabets with another fixed formatting.
Otherwise, I will spend the time creating a wheel probably someone else already perfected.
- peiyezhuAug 01, 2023Bronze Contributorhttp://e.anyoupin.cn/EData/tree/t/ToDoList/index.php
when play with HTML,no any problem with EMOJI.
I guess bosinander has provide some ways to hanlde with it in Excel.
I mean it should be easier to handle it with Markdown or HTML rather than VBA.