SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

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... 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


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.