HarrySiers
Board Regular
- Joined
- May 27, 2015
- Messages
- 61
Hello Forumers,
In cell A1 I have the following content:
Red Blue White
In cell B1 I would like to have the following content:
(1) Red (2) Blue (3) White
The macro should work for any number of words in cell A1.
Any solution? And is it possible to have the added parts (1), (2), (3) etc. displayed in a particular font, say, a small font Times Roman 9 points, if the rest of the content in A1 (Red, Blue, White) would be, for instance, Times Roman 14 points, or is that asking too much, programmingwise ?
Thank you in advance,
Harry
In cell A1 I have the following content:
Red Blue White
In cell B1 I would like to have the following content:
(1) Red (2) Blue (3) White
The macro should work for any number of words in cell A1.
Any solution? And is it possible to have the added parts (1), (2), (3) etc. displayed in a particular font, say, a small font Times Roman 9 points, if the rest of the content in A1 (Red, Blue, White) would be, for instance, Times Roman 14 points, or is that asking too much, programmingwise ?
Thank you in advance,
Harry