McKommander
New Member
- Joined
- Sep 20, 2017
- Messages
- 9
I am looking for help in writing a macro to help me in deleting an empty row with in a cell for all the cells in a column. I only need one line in a cell.
Is there a way to write a Macro to delete the empty rows within each cell so that only one row exists, all the way down the column? My data has one only 2 lines with the first line empty. I can't break the text apart using the text to column function because excel seems to ignore any data in the second line.
Thanks
Is there a way to write a Macro to delete the empty rows within each cell so that only one row exists, all the way down the column? My data has one only 2 lines with the first line empty. I can't break the text apart using the text to column function because excel seems to ignore any data in the second line.
Thanks