Hello Everyone,
I believe this one will be a challenge, but if anyone is interested...
NOTES:
1.) I am looking for this to be done in Column A, but to ANY row selected, the row numbers in the example below are just an example.
2.) Ideally I would like this to be able to be done to both single or multiple SELECTED rows, but if too complex, just single rows will be fine.
EXAMPLE #1
BEFORE
|__________A__________|_________B_________|
1 apple orange banana grapes pear
2 mango
3
If you select A1 and apply this macro you get the following
AFTER
|__________A__________|_________B_________|
1 apple orange banana
2 grapes pear mango
3
As you can see it removes the space in front of "grapes pear" and adds a space after it and then adds it to the beginning of the next rows text, which in this case is "mango".
EXAMPLE #2
BEFORE
|__________A__________|_________B_________|
1 apple orange banana grapes pear
2
3
If you select A1 and apply this macro you get the following
AFTER
|__________A__________|_________B_________|
1 apple orange banana
2 grapes pear
3
If there is no data in the next row, it removes the space in front of "grapes pear" and just adds it to the next row.
As I mention above, ideally I would be able to apply this to MULTIPLE selected rows, but as you can see, this might get too complex.
If anyone has any questions, please let me know.
Thank You to whoever reads this and to anyone who tries to create something.
I believe this one will be a challenge, but if anyone is interested...
NOTES:
1.) I am looking for this to be done in Column A, but to ANY row selected, the row numbers in the example below are just an example.
2.) Ideally I would like this to be able to be done to both single or multiple SELECTED rows, but if too complex, just single rows will be fine.
EXAMPLE #1
BEFORE
|__________A__________|_________B_________|
1 apple orange banana grapes pear
2 mango
3
If you select A1 and apply this macro you get the following
AFTER
|__________A__________|_________B_________|
1 apple orange banana
2 grapes pear mango
3
As you can see it removes the space in front of "grapes pear" and adds a space after it and then adds it to the beginning of the next rows text, which in this case is "mango".
EXAMPLE #2
BEFORE
|__________A__________|_________B_________|
1 apple orange banana grapes pear
2
3
If you select A1 and apply this macro you get the following
AFTER
|__________A__________|_________B_________|
1 apple orange banana
2 grapes pear
3
If there is no data in the next row, it removes the space in front of "grapes pear" and just adds it to the next row.
As I mention above, ideally I would be able to apply this to MULTIPLE selected rows, but as you can see, this might get too complex.
If anyone has any questions, please let me know.
Thank You to whoever reads this and to anyone who tries to create something.
Last edited: