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...
sunnyschindler
Jul 27, 2023Brass Contributor
Thanks, I learnt more today but should have mentioned that my need is to mobile text a string; by TEXTJOIN LOOKUP outputs.
The best I can come up with (w/o VBA) paste TEXTJOIN output into WORD APP to substitute "control characters" (which, similar to your suggestion, wrapped around each LOOUP output) with superscripts and subscripts depending according to "control characters". Appreciate your help!
The best I can come up with (w/o VBA) paste TEXTJOIN output into WORD APP to substitute "control characters" (which, similar to your suggestion, wrapped around each LOOUP output) with superscripts and subscripts depending according to "control characters". Appreciate your help!
peiyezhu
Jul 27, 2023Bronze Contributor
mobile text a string;
what do you mean this?
can.you. upload a file rather than screenshot image and show your expected result?
how about html like below?
https://answers.microsoft.com/en-us/msoffice/forum/all/how-do-i-highlight-cells-based-on-data-from/aeae4552-08f5-4742-92d6-4885298fa5bf
what do you mean this?
can.you. upload a file rather than screenshot image and show your expected result?
how about html like below?
https://answers.microsoft.com/en-us/msoffice/forum/all/how-do-i-highlight-cells-based-on-data-from/aeae4552-08f5-4742-92d6-4885298fa5bf