Forum Discussion
Convert Text to specific numbers
I have the data below: This is an attendance record. The data in the cells need to be converted into certain numbers as shown below: ...
Select the range with letters.
Format the range as Number with 1 decimal place.
Press Ctrl+H to activate the Replace dialog.
Enter P in the Find what box and 1.5 in the Replace with box.
Click Replace All.
Enter L in the Find what box and 1 in the Replace with box.
Click Replace All.
Enter E in the Find what box and 0.5 in the Replace with box.
Click Replace All.
Enter U in the Find what box and 0 in the Replace with box.
Click Replace All.