remove characters before "="

[ymeyaw]

Dear all,

I had a spreadsheet which i wish to remove all characters from "=" and before. How should i do that?

example:

timer=100 -->>> 100


thanks

[ymeyaw]

Hi all,

i know this can be done by just using RIGHT(A1,3). However, i have different cells where everyone does not have the same len.

example:

timer=100 -->100
target=2333--> 2333
test=400 --> 400


How should i remove that?

[Leith Ross]

Hello Ymeyaw,

You the Instr function to find the "=" and then split the string using MID. . This macro will change every cell on the worksheet that has an "=" in it.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[Paul]

Or if you wanted to do it with a formula rather than vba, use:

=RIGHT(A1,LEN(A1)-(FIND("=",A1)))

Change the cell reference to fit in your spreadsheet, then copy down. It will pull only data after the = sign.

[ymeyaw]

Hi,
Thanks for ur fast response. I just tried it but encounter error "run time error "13" type mismatch.