remove space in excel formula

[kevinkhan]

ok i have this text in J3

Atomic Kitten - Whole World I want to extract the characters after the - sysmbol (not including the first space) I have this formula so far ="#"&RIGHT(J3,LEN(J3)-FIND("-",J3)) but its producing a result like this # Whole World what formula do i use to exclude the space before the first letter which in this case its W <colgroup><col width="100"></colgroup><tbody> </tbody>

<colgroup><col width="303"></colgroup><tbody>
</tbody>

 

[Momentman]

Add a TRIM function

Like =TRIM(RIGHT(J3,LEN(J3)-FIND("-",J3)))

or

="#"&TRIM(RIGHT(J3,LEN(J3)-FIND("-",J3)))

Depending on what you want to achieve

 

[VoG]

Try

="#"&RIGHT(J3,LEN(J3)-FIND("-",J3)-1)

 

[kevinkhan]

That worked thanks very much.

 

[vds1]

One more way,

="#"&REPLACE(J3,1,FIND("-",J3,1)+1,"")

 

[Rick Rothstein]

And one more way...

If there is always a space after the dash
---------------------------------------------------------
="#"&MID(J3,FIND("-",J3)+2,99)

If the space after the dash might be missing
---------------------------------------------------------
="#"&TRIM(MID(J3,FIND("-",J3)+1,99))