Thread: remove "+" from =+ABCD.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chuck[_12_] Chuck[_12_] is offline
external usenet poster
  
Posts: 4
Default remove "+" from =+ABCD.
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

Reply With QuoteReply With Quote