Need some special formula

[raviprakash369]

Hi,
please find the below description in the image and do the needful to create special formula.
special.JPG
Thanks in advance.

Regards,
Ravi

[Phuocam]

Try this ...

Before: =LEFT(A2,FIND("±",A2)-1)

After: =REPLACE(A2,1,FIND("±",A2),"")

[FDibbins]

raviprakash369 welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )