Insert rows

I am trying to create a macro that will insert a row if the first character in a cell is different to the cell below. I've tried various options but cannot get the macro to see the first characters of the cells.

Example:

aaa
abb
baa
bbb
ccc
ccd
ddd
dde

would become:

aaa
abb

baa
bbb

ccc
ccd

ddd
dde

Thanks for any help.

You can try to use this macro:

Please Login or Register  to view this content.

Regards,
Antonio

Exactly what I needed, thanks so much for that.