Inserting Spaces

J

john

Hi All, I have a spreadsheet with about 1000 rows.
My problem is that I have to insert a space between the last and second last
number. Example, 1234560 needs to be changed to 123456 0.
Can anyone give me a formula to do this. TIA.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Space at end of multi page list to accommodate new entries 1
Inserting Spaces 4
White space above heading inconsistently applied 1
how to check MS Word paragraph line spacing using vba script 1
Autonumber field in Excel that behaves the same as Access 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Spacing in Column headers 1
Match issue 3

Top