Referencing 2 Choice columns in an IF statement

I am trying to add a Calculated Value Column with a simple If statement that goes like this there are 4 columns i am working with. the column with the calculated value being Column1, Column2, Column3 and Column4. Column2, Column3, Column4 are all are all Choice Columns. The formula is "working" but the way is returning the value is with ;# at the beginning and end of the Value like this:  ;#Value;# 

 I have something depending on this column and need it to not have the semicolon and number sign. (I have very little experience with formatting SP with formulas)

 Here is the formula i entered. 

=IF([Column2]="Name",[Column3],[Column4])