How can I prevent extra spaces when pasting text from Word to Excel?

Question

for example,

1. Each morning, the sun rises in the east.
   it is showing like this when I remove one of the spaces it will remove all extra space.

Answer 1

Thank you for providing a solution and taking the time to address my query. I truly appreciate your assistance and the detailed response.

It’s clear that this might be related to a deeper programming aspect, and I understand these changes are often implemented to enhance the overall functionality of the application.

Once again, I’m grateful for your support and guidance. I’ll continue exploring the options and workarounds provided.

Best regards,

Muhammad Usman

Answer 2

I am glad we could reach an agreement. There are not many Excel users as courteous and friendly as you, and I truly value every friendly Office user I come across. If you have any further questions, please feel free to ask in the community, I'll do my best to help you.

Additionally, if my explanations or the alternative solutions I shared were helpful to you, please select 'Yes' under the response that assisted you.

It will highlight the response and make it easier for other users encountering the same query to find this thread through search engines. Thank you for your cooperation.

Have a nice day!

Thomas