+ Reply to Thread
Results 1 to 3 of 3

Seperate cells by adding null line according to numbers

  1. #1
    Registered User
    Join Date
    04-28-2009
    Location
    Athens
    MS-Off Ver
    Excel 2007
    Posts
    49

    Seperate cells by adding null line according to numbers

    Hello excel forum readers!

    I am looking for a time saver macro,pretty easy to make i guess,as the theory is not difficult...but i am too newbie to make it

    So i have an xls that has like 20k lines on Column A!And i have to seperate the numbers...
    I count the first 4 digits and I have to do it by adding a cell between them.

    Example :
    27289802
    27289902
    27289915
    27289915
    (add a null line)
    27290202
    27290302
    27290316
    27290402
    27290416
    27290431
    27290701
    27290703
    (add a null line)
    34100105802
    34100105815
    (add a null line)

    As a said everything happens in Column A.

    I would really appreciate if someone can help me...it's a living hell trying to do it manually!
    Last edited by alogoc; 07-13-2009 at 07:10 AM.

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Seperate cells by adding null line according to numbers

    Like this?
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-28-2009
    Location
    Athens
    MS-Off Ver
    Excel 2007
    Posts
    49

    Re: Seperate cells by adding null line according to numbers

    Extreme thank you for your fast reply!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1