Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I want to create a calculated column to have values without the '#;' in it. What is the formula to do that?

share|improve this question

2 Answers 2

Assuming you just want to replace it once, you can use this formula:

=IF(ISNUMBER(FIND("#;",[MyColumn])),REPLACE([MyColumn],FIND("#;",[MyColumn]),2,""),[MyColumn])
share|improve this answer
    
Chris, thank you for formula. Will try using it. –  codepush Mar 8 '12 at 18:49

there are lots of formulas here... http://msdn.microsoft.com/en-us/library/bb862071.aspx hopefully you can find the one you're looking for there.

share|improve this answer
    
That's a good source for formulas. Need to find a nice fit. Thanks. –  codepush Mar 8 '12 at 18:52

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.