Results 1 to 16 of 16

Separate into columns

Threaded View

  1. 02-21-2011, 05:43 AM #1
    krrish
    krrish is offline
    Registered User
    Join Date
    02-21-2011
    Location
    INDIA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Separate into columns

    i have a data like this..i want to seperate (|)..with this symbol..given the data below..plz giv me solution..

    80000045007 CGC_TERBINAFINE STAGE-III , TERBINAFINE STAGE-III AT BLOCK-B
    C4031620 Disodium Hydrogen Orthophosphate 9487 KG 4745121 DIRECT
    TAPIAORATORIES PVT LTD 1901 L Street, NW, Suite 700 Washington washingtondc
    united states DC 20036 1-202-293-2537

    EX:

    80000045007| CGC_TERBINAFINE STAGE-III , TERBINAFINE STAGE-III AT BLOCK-B|
    C4031620| Disodium Hydrogen Orthophosphate| 9487| KG| 4745121| DIRECT|
    TAPIAORATORIES PVT LTD| 1901 L Street, NW, Suite 700| Washington| washingtondc|
    united states| DC 20036| 1-202-293-2537|
    Last edited by krrish; 03-01-2011 at 01:15 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1