remove "+" from =+ABCD.
1) is the = sign displayed all the time, or only when you select the cell
2) what do you mean the RIGHT() function 'is not working'
3) have you tried search and replace - searching for either "=+" or for "+"
and replacing with nothing?
"Chuck" wrote:
Hi, I have got data in a spreadsheet and the string values came as "=
+ABCDE".
I want to exctract ABCDE from this string.. any suggestions?
I tried RIGHT funcation =RIGHT(A1, LEN(A1)-1) but it is not working.
Thank you,
hj
|