Hi all,
I am trying check in column A, which contains and list of categories, of which I only have to copy the first category from the cell and paste it to corresponding cell in column B.
The formula I am using is with if statement, which works fine for multi category cells but returns error for single category cell.
Please refer to workbook attached.
It will be great if someone can help.
Thanks
Praney![]()
Bookmarks