how to split vertial data into saperate cells


  1. cheekugreat
    Posts : 2
    windows 7 64 Bit
       New #1

    how to split vertial data into saperate cells


    Hi,
    i have a data on following pattern

    and want to split it into multiple rows like this.

    please guide if these's any function or formula to do this task.
    thanks.
      My Computer
    Quote Quote

  3. maxie
    Posts : 18,415
    windows 7 home 64bit
       New #2

    Hi Welcome to Seven Forums ... Read the Link below ...


    Merge and unmerge cells - Excel
      My Computer
    Quote Quote

  4. cheekugreat
    Posts : 2
    windows 7 64 Bit
    Thread Starter
       New #3

    doesn't help.
      My Computer
    Quote Quote

 

  Related Discussions
Format cells in excel 2007
in Microsoft Office

I have a spreadsheet made in excel 2007. In one of the cells is a number with three zeros in front of it and one zero at the end. However it always drops the zeros and shows only the other numbers. I select the cell and click on "format cells", but there is nothing I see that will show all the...
I recently built a new computer that has an ssd intended for the os, the problem is it isnt big eneugh for all the program files, and user data. I want to move that part of the operating system over to the hard drive but have no idea how to go about it. Any help would be appreciated, thanks
All, I created a five year pro forma financial model for my business. The spreadsheet makes extensive use of worksheet formulas and macros. I also added a sheet to track actuals (numbers extracted, by hand, from QuickBooks monthly). Certain formulas in the spreadsheet are based on values...
I hate to admit this but its been way to long since I have had to do this for a client much less for my wife's PC. I have a New computer that my son just built for my wife. It has a tripple core processor etc. 8 gig of Memory and a 2 TB hard disk. He configured it as one drive vs a...
Excel un password cells
in Microsoft Office

Hi I have a excel sheet that some cells are password protected i have no idea what the password is any ideas how i can find the password or any software that will find it, so i can change the cell contents. Thanks
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 05:18.
Find Us