On Nov 9, 9:27 am, John Bundy (remove) wrote:
If possible, select the column that has that, CTL-H type =+ in the to box,
leave the bottom blank and replace all.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.



"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- Hide quoted text -

- Show quoted text -

Thanks, that worked :)