I converted a text file to 2007excel file. There was a cell containing this:
=-CLASS FURNITURE
Excel will show it as #NAME?
I need to extract this text "CLASS FURNITURE" so as to concatenate it with adjacent cells (to get a vendor name). I tried many functions (right, text, substitute,..) to no avail.
Please help me.
Thanks in advance.
=-CLASS FURNITURE
Excel will show it as #NAME?
I need to extract this text "CLASS FURNITURE" so as to concatenate it with adjacent cells (to get a vendor name). I tried many functions (right, text, substitute,..) to no avail.
Please help me.
Thanks in advance.