Results 1 to 3 of 3

break the data into 2 rows with same cell

Threaded View

  1. #1
    Registered User
    Join Date
    08-19-2009
    Location
    HK
    MS-Off Ver
    Excel 2003
    Posts
    4

    break the data into 2 rows with same cell

    I have more than 1000 rows of data , I would like to break the data into 2 rows within the same cell in one of the column if the data contain "/".
    A
    1 ISN - 1234/ 009
    2 ISN - 1234343434/ 005
    3 ISN - 12/ 003

    Change to
    A
    1 ISN - 1234/
    009
    2 ISN - 123434343/
    005
    3 ISN - 12/
    003


    Of course I could use "ALT + Enter" in each cell to break the data into 2 rows. However, is there any ways to do it more efficiently?
    Last edited by sss047; 04-12-2011 at 03:42 AM.

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