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: ...
Go through the find and replace function
First select the data where you want to replace text with numbers .after that press ctrl+h
Enter the find what as "p" or which text you want replace and enter value in replace with( ex 1.5) and select replace all
First select the data where you want to replace text with numbers .after that press ctrl+h
Enter the find what as "p" or which text you want replace and enter value in replace with( ex 1.5) and select replace all