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.