Forum Discussion
Problem pasting with "-"
Hi all, when pasting the following in Excel I get the #NAME error because Excel makes it into a formula by adding "=" in front. "- protein chocolate" becomes "=- protein chocolate" which giv...
To keep the hyphen/minus prefix the formula with a single quote / apostrophe.
Otherwise pre-format the cell as 'text' using number formatting. SUBSTITUTE or Text to Columns would then remove the hyphen.
Thanks PeterBartholomew1
I now pre-format the cell with the number formatting and substitute to remove the hyphen.
Thanks again.