The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

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

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

0
Votes
3
Answer

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?

3 Answers

365 Team
0
Votes

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

0
Votes

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!!

365 Team

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

×
LAST CHANCE
Ready to Learn Data Science?
50% OFF