mrmagoo_83
Board Regular
- Joined
- Mar 7, 2005
- Messages
- 82
I am pulling same data from a webpage, and need to convert a few cells, as they are causing issues.
For Example, one of the colums contains names of teams and such, one of the team names is "=V="; however, Excel returns the @NAME? error to me, even though the cell is formatted as text. In order to get the cell's content to show up correctly I have to add a single quote mark in front of the first "=".
Is there a way to either add the quote mark to the beggining of every cell, or to force this cell to show the name correctly, instead of the @NAME?.
For Example, one of the colums contains names of teams and such, one of the team names is "=V="; however, Excel returns the @NAME? error to me, even though the cell is formatted as text. In order to get the cell's content to show up correctly I have to add a single quote mark in front of the first "=".
Is there a way to either add the quote mark to the beggining of every cell, or to force this cell to show the name correctly, instead of the @NAME?.