Counting from Right side

[abhishukla15]

Hi,

I want to eliminate everything in left after a word.
Example: Suppose I have below number

a) 123 # 456
b) 12 # 21
c) 1234567 # 7654321

The output which I require is everything after #, as :

a) 456
b) 21
C) 7654321

Could you please help?
Thanks in advance.

 

[mailosid]

Hi,

I want to eliminate everything in left after a word.
Example: Suppose I have below number

a) 123 # 456
b) 12 # 21
c) 1234567 # 7654321

The output which I require is everything after #, as :

a) 456
b) 21
C) 7654321

Could you please help?
Thanks in advance.

Try This:

=TRIM(RIGHT(A1,LEN(A1)-SEARCH("#",A1)))

Note:Replace A1 with required cell reference

 

[abhishukla15]

Thanks. actually in real scenario I have below values from :
[TABLE="width: 209"]
<tbody>[TR]
[TD]a) 6 days 2.18 hours [/TD]
[/TR]
[TR]
[TD]b) 11 days 8 hours
c) 1111111 days 8.00000004 hours
from which I want to extract

a) 2.18
b) 8
c) 8.00000004

I have below formula in place
RIGHT(SUBSTITUTE(LEFT(AD136,(LEN(TRIM(AD136))-5)),"days","#"),LEN(SUBSTITUTE(LEFT(AD136,(LEN(TRIM(AD136))-5)),"days","#"))-FIND("#",SUBSTITUTE(LEFT(AD136,(LEN(TRIM(AD136))-5)),"days","#"),1)))

it will be good if you can help me with something good.
[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

 

[JackDanIce]

Adjust the cell reference and try:

=TRIM(SUBSTITUTE(MID(A1,FIND("days",A1)+5,LEN(A1)), "hours", ""))

 

[Rick Rothstein]

Give this formula a try...

=TRIM(LEFT(RIGHT(SUBSTITUTE(A1," ",REPT(" ",100)),200),100))