Forum Discussion
Solved
Convert text into number in Excel
Hi, I was wondering if anyone was able to help. I've been racking my brains for ages and search countless forums to try and figure this out. I have a Microsoft form that has a Likert scale ques...
Unfortunately, your screenshots are so small that I cannot read them.
Press Ctrl+H to activate the Replace dialog.
Enter None of the time in the Find what box and 1 in the Replace with box, then click Replace All.
Repeat for the four other options.
Unfortunately, your screenshots are so small that I cannot read them.
Press Ctrl+H to activate the Replace dialog.
Enter None of the time in the Find what box and 1 in the Replace with box, then click Replace All.
Repeat for the four other options.
HansVogelaar to me you are a genius! Its worked. After hours of searching this has worked and its so simple. Thank you so much for your help.