convert letter to number in a column

[michael coughlin]

I want to convert the letter "W" to "5" and the letter "L" to "-5" in a column

 

[hiker95]

michael coughlin,

It would help if we could see your actual raw data workbook/worksheet, and, what the results (manually formatted by you) should look like.

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com

 

[Rick Rothstein]

I want to convert the letter "W" to "5" and the letter "L" to "-5" in a column

Assuming those letters are the only thing in the cells, select the column and then use Excel's Replace dialog box (CTRL+H) to replace the letters with those numbers.

 

[michael coughlin]

https://www.dropbox.com/s/wumxr1et6zj4ssn/HEARTS.xlsx?dl=0

 

[Rick Rothstein]

https://www.dropbox.com/s/wumxr1et6zj4ssn/HEARTS.xlsx?dl=0

I don't see the letters W or L that you want converted to 5 or -5 in the worksheet sample you posted.

 

[michael coughlin]

column F

 

[Rick Rothstein]

column F

Column F is empty on the worksheet at the link you posted in Message #4 . Your original post said "I want to convert the letter 'W' to '5' and the letter 'L' to '-5' in a column"... if there are no letters in Column F, then what is supposed to be converted?

 

[michael coughlin]

column F will get the letters either L or W

 

[Rick Rothstein]

column F will get the letters either L or W

That is different from what you asked originally. Is the criteria to put a W in Column F if Column G's (same row) value is positive and L if negative? If so, what should go in the cell if Column G's value is 0?

 

[michael coughlin]

you're making this too difficult. I want to put a W in column F to equal $5.00 or an L to equal -$5.00