Inserting row after certain texts

Joined
Jan 5, 2012
Messages
1
Reaction score
0
Hello,

I have an excel document with 7000 rows

I need to insert a row after certain text. The problem is that there are multiple texts that I want to separate.

For example:
Column A

Test A
Test B
Test C:Yellow
Test C:Green
Test C:Blue
Test D:Lake
Test D:Ocean
Test E
Test F

Basically what I want to do is insert a ROW after A, B, C, D, E, F

It will look like this
Column A
Test A

Test B

Test C:Yellow
Test C:Green
Test C:Blue

Test D:Lake
Test D:Ocean

Test E
Test F

If there is a way to maybe use the semicolon to help determine that would be easier too, because my data has a semicolon if there are multiple types or no semicolon if its just single.

Please let me know what I can do. I am a beginner.

Thank you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top