marreco
11-02-2012, 08:55 AM
Hi.
I need to move (via VBA), texts separated by a dash (-) to the bottom line.
However column "B" must follow the strokes according to the number of rows.
eg
WORKSHEET "BEFORE"
Column "A" ---------------- Column "B"
Itapemerim - Vila Velha Espirito Santo
WORKSHEET "RESULT"
Column "A"--- Column "B"
Itapemerim Espirito Santo
Vila Velha Espirito Santo
In this example have only two pieces, more cases can have 10 or more and thus have 10 or more lines depending on the case.
Vaje my attachment
I need to move (via VBA), texts separated by a dash (-) to the bottom line.
However column "B" must follow the strokes according to the number of rows.
eg
WORKSHEET "BEFORE"
Column "A" ---------------- Column "B"
Itapemerim - Vila Velha Espirito Santo
WORKSHEET "RESULT"
Column "A"--- Column "B"
Itapemerim Espirito Santo
Vila Velha Espirito Santo
In this example have only two pieces, more cases can have 10 or more and thus have 10 or more lines depending on the case.
Vaje my attachment