Forum Discussion
Excel formula no longer returning values to multiple columns
Hi Hans - thank you for your response. Whilst I was trying to put together an example, I came across the solution entirely by accident, so thank you for putting me on the right path!
Solution here in case anyone else has this issue:
The original data was in a single cell, separated by a comma ',' and a space ' ' - when Excel moved data into Columns using the delimited ',' option, it left that single blank space at the start of every column except the first one.
This meant that when the formula looked for an exact match to the column header, it couldn't find any, because of the extra space at the start.
Once the space was removed, everything appeared as it should have done. Hopefully this is helpful to anyone else who missed the obvious error like I did.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Hi Hans - thank you for your response. Whilst I was trying to put together an example, I came across the solution entirely by accident, so thank you for putting me on the right path!
Solution here in case anyone else has this issue:
The original data was in a single cell, separated by a comma ',' and a space ' ' - when Excel moved data into Columns using the delimited ',' option, it left that single blank space at the start of every column except the first one.
This meant that when the formula looked for an exact match to the column header, it couldn't find any, because of the extra space at the start.
Once the space was removed, everything appeared as it should have done. Hopefully this is helpful to anyone else who missed the obvious error like I did.
Thanks for the feedback.
