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


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.




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!


Answer the Question

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