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 :

a) 6 days 2.18 hours

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.

<tbody>
</tbody><colgroup><col></colgroup>

 

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