Hi all
Appreciate help with the following 2 situations
Situation 1:
I copy and paste a line of text into a single cell
The single cell contains words in Bold
Italics
Normal
eg Cell A1: A Beautiful sunny day
Want:
Separate the 3 categories(bold,italic,normal) into 3 separate cells.
Situation 2:
Want:
Find an asterisk in a row and delete it, along with any remaining text/numbers in the row to the right of it.
Many Tks.
Bookmarks