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

remove "+" from =+ABCD.
 

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

remove "+" from =+ABCD.
 

With ActiveCell
.Value = "=" & Right(.Formula, Len(.Formula) - 2)
End With


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Chuck" wrote in message
ups.com...
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

remove "+" from =+ABCD.
 

What does "not working" mean? Wrong result? What? Error?

Shouldn't it be

=RIGHT(A1, LEN(A1)-2)
?


Maybe there are leading spaces in the cell?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Chuck" wrote in message ups.com...
| 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
|

remove "+" from =+ABCD.
 

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 :)

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