If cell starts with, add content to previous cell & delete row

[bvm.secur]

Hi All,

I have some problems with some data where sometimes the postal code & email address are in 1 row, sometimes seperated in two rows.

I would like to fix it with a macro to always put them in a single row (with a line break). This is what I would like to do (example in the file attached, with those cell numbers)

- If the cell starts with "E-mail:", let's say on row X --> go to previous row --> add line break & AX content to AX-1 --> delete AX row --> repeat until no row starts with "E-mail:"
In my example, it's basically: Cell A10 starts with e-mail --> go to A9 --> add a line break and A10 content --> delete A10 row

Of course, this should work for several hundreds of similar data.

Thank you already for your help !

[Mumps1]

Try:

Please Login or Register  to view this content.

[bvm.secur]

Works like a charm, thank a lot !

[Mumps1]

You are very welcome.