Only show value after 'specific character'?

[#1]

Hi All,

I tried to find this answer in the community but could not find anything.

I am pulling information from sharepoint and some of the data comes through with extra Numbers and characters, for example "1201;# ABCD Funding 2013-II,ltd."  I tried using purgechar(Legal_Name, '0123456789;#') but the problem i run into is that i need all the information after the # including the 2013.  The data is consistent when pulled through, so i am looking for a way to pull in the data after '#'.  I can't use the right count function becasue the initial 1201 number may be different. 

Thank you for your help!

Nicholas

[#2 · Accepted solution]

To get anything after the # sign:

=Right(YourField,Len(YourField)-Index(YourField,'#'))

[khadeer]

PFA

[#4]

Hi All,

Thank you for yoru help. I was able to get the function working correctly.

Thanks again!

Nicholas