Forum Discussion
List formatting help needed
I've never posted her before so please forgive me if this question is formatted confusingly. To keep it simple, I have a list of books with author names that I'd like to format in excel. I start...
Let's say your list is in A1:A300.
In (for example) C2, enter the formula
=WRAPROWS(TOCOL(A1:A300, 3), 2)
I'm not sure if it didn't work or if I did it wrong. My list is in Column A and spans from Row 1 to Row 554.
The pattern in column A is as follows: Title A (A1), Author A (A2), blank (A3), Title B (A4), Author B (A5), blank (A6)...
It started as plain text like the below and I pasted right into excel:
Title
Author
-
Title
Author
-
etc.
Are A3, A6, etc. really blank, or do they contain a space or a - ?
- They are blank
