Copy content beginning after a special Symbol

[lalau]

Hey all I have looked around but could not find the correct answer I have to copy some excel content for a report. The information is downloaded from a Sharepoint database. By downloading the sistem automatically adds the assigned sistem number before the Attribute:

276;#Electrical company S.A.

I need to copy this clean without the automaticcally asigned number plus symbol 276;#

I tried to apply this formula: =RIGHT(B2;(LENGHT(B2)-SEARCH("#";B2))) but this doesn´t work out I hope someone could help.

Thank you very mu

[AliGW]

Which version of Excel do you have?

Try this:

=MID(A1,FND("#",A1)+1,99)

[lalau]

Hello AliGW,

thank you very much for your help I am using this version2102. I will try your formula.

BG

Laura