Forum Discussion
sunnyschindler
Jul 25, 2023Copper 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...
sunnyschindler
Jul 31, 2023Copper 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.
peiyezhu
Aug 01, 2023Bronze Contributor
http://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.
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.