Cell formatting

[damionblaise]

The data has an extra line with a space as follows:

blank space
data
blank space

I need to move the text to columns but the data is blank, I'm assuming because the first line is blank.

Thanks.

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/excel-questions/907313-cell-formatting.html

Please do not post the same question multiple times. All clarifications, directly-related follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).