Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

How to make space between in more than 1000 numbers at a single time

0

I was using excel to make some searches on some other documents. But in excel it has whole number but in other document to seach i have to make some space between that numbers. so making space between that numbers is consuming more time. so i want to make gap between numbers at single time. how to do that activity by using macros or ctrl+h. for exampe change this number 123456789 like this 12 345 67 89.

Answer
Discuss

Answers

1

Welcome to the forum!

Use a formula like this and you can copy it down for your whole list.

=LEFT(A1,2)&" "&MID(A1,3,3)&" "&MID(A1,6,2)&" "&RIGHT(A1,2)

This assumes the list starts in cell A1.

hope this helps!

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login