Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
To get anything after the # sign:
=Right(YourField,Len(YourField)-Index(YourField,'#'))
To get anything after the # sign:
=Right(YourField,Len(YourField)-Index(YourField,'#'))
PFA
Hi All,
Thank you for yoru help. I was able to get the function working correctly.
Thanks again!
Nicholas