SP2007 formula to remove every occurrence of '#;' from a field

Question

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

theChrisKent · Answer 1 · 2012-03-08 16:26:54Z

up vote 1 down vote

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

=IF(ISNUMBER(FIND("#;",[MyColumn])),REPLACE([MyColumn],FIND("#;",[MyColumn]),2,""),[MyColumn])

answered Mar 8 '12 at 16:26

theChrisKent
989314

Chris, thank you for formula. Will try using it. – codepush Mar 8 '12 at 18:49

ironman99 · Answer 2 · 2012-03-07 21:24:29Z

up vote -1 down vote

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.

answered Mar 7 '12 at 21:24

ironman99
535312

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

2 Answers