Hello All Excel Gurus out there,
I need help with designing VBA code to do the following:
<colgroup><col><col></colgroup><tbody>
</tbody>
Basically, all I want to do is look inside the cell for all the * except the first one and replace that with a line break and a "*"
I have over 15,000 cells with a variable number of "*" and I do not want to place a line break if one already exist before the "*".
Thanks in advance for any help.
I am new to the forum. What is the best way to paste a table into the message?
I need help with designing VBA code to do the following:
Example | Desired Outcome |
*First Line*Second Line*Third Line | *First Line *Second Line *Third Line |
*First Line *Second Line*Third Line | *First Line *Second Line *Third Line |
<colgroup><col><col></colgroup><tbody>
</tbody>
Basically, all I want to do is look inside the cell for all the * except the first one and replace that with a line break and a "*"
I have over 15,000 cells with a variable number of "*" and I do not want to place a line break if one already exist before the "*".
Thanks in advance for any help.
I am new to the forum. What is the best way to paste a table into the message?