How to solve the "Move the text and numbers to the right" query in Special Select Lesson

Question

I was going through the Introduction to Excel Video module within which the bit about the Special Select Lesson where we selectively find out specific cells with certain criterion and fill up with a desired value in there...

I was able to solve the 1st out of 2 exercises for this chapter, where I was able to select blank cells and fill up the same with n.a. value. However, while the 2nd exercise which asks to "Move the text and Numbers to the Right" - I'm little puzzled on this where how to use the Special Select Formula (if that's possible here) to get this done!

Although I was able to do it by selecting the entire table and using ribbon, was able to move the text and numbers to right, wanted to know if we could do this using the Special Select?

Answer 1

Hello, Thanks for reaching out! We have provided the solution file with guidance for you to take a look. Please take a look. Best, Ned

Answer 2

Hi Ned, Thanks for your response. Yes I did checked out the solution file, however, there I cannot find the formulae / formatting that is set within the format cells as when I try to see what is set inside the format cells, I only find default General set inside Custom option.. Even after me trying the way it was shown in the video of the exercise, I'm not able to get the answer as expected!!

Answer 3

Hi Satish, On the right hand side you have step-by-step instructions on how to solve the exercise, right? Best, Ned

How to solve the "Move the text and numbers to the right" query in Special Select Lesson

Submit an answer