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...
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
For what it's worth, here is the workbook I used to test. Does it provide a clue?
- Turns out there were spaces, I should've double checked! I found and replaced to remove all the spaces and the formula worked, thank you so much!! ❤️