I have a huge spreadsheet that I'm trying to consolidate some lines in.
I have information in Column A, B, C and D, so I need to be able to select cells in any Column, but 1 at the time.
What I want to do is select 2 (or more) cells in Column A, and when I run the VBA it will:
- Concatenate the text from selected cells, in the first cell I selected, AND
- I want the text from each cell to be in it's separate line (same as the Alt+Enter), AND
- I want to add "a)", "b)", etc. in front of the text of each cell.
Original Data can look like this (data in 4 separate cells):
<tbody>
</tbody>
Data after I run the VBA, look like this (Data is now in 1 cell w/alphabetic bullet/numbering);
<tbody>
</tbody>
I have information in Column A, B, C and D, so I need to be able to select cells in any Column, but 1 at the time.
What I want to do is select 2 (or more) cells in Column A, and when I run the VBA it will:
- Concatenate the text from selected cells, in the first cell I selected, AND
- I want the text from each cell to be in it's separate line (same as the Alt+Enter), AND
- I want to add "a)", "b)", etc. in front of the text of each cell.
Original Data can look like this (data in 4 separate cells):
Audi - is German |
Bentley - is expensive |
Chevy - is a solid car |
Dodge - have a long history with Pickup Trucks |
<tbody>
</tbody>
Data after I run the VBA, look like this (Data is now in 1 cell w/alphabetic bullet/numbering);
a) Audi - is German b) Bentley - is expensive c) Chevy - is a solid car d) Dodge - have a long history with Pickup Trucks |
<tbody>
</tbody>