Results 1 to 4 of 4

Losing Data When Converting Delimited Data From Text To Column

Threaded View

  1. #1
    Registered User
    Join Date
    06-05-2012
    Location
    mumbai
    MS-Off Ver
    Excel 2007
    Posts
    60

    Losing Data When Converting Delimited Data From Text To Column

    I have data downloaded from website, when I click on the cell, the formula bar appears blank when it should display my text. On the attached workbook, cell "A2" is an example. Notice how "14q32.3 by FISH IGH gene rearrangement (ALL, NHL) Blood" appears in the cell but not the formula bar. I can easily re-type the string into the cell, I want to separate Bold text from the normal text. But when I try to do so using Text To Column, Small Data Gets Disappear.

    I tried using CHAR formulas to change the format of the cell, in that case SPACE between FISH and IGH gets disappear. i.e("14q32.3 by FISHIGH gene rearrangement (ALL, NHL) Blood")

    Please help me out !!

    sample data file is attached.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Code convert data to tab delimited and write data to text file | Not Working
    By lbl159 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-07-2015, 06:40 AM
  2. Replies: 1
    Last Post: 07-16-2014, 06:35 PM
  3. Converting Pipe Delimited Data String into Seperate columns using VBA Macro
    By mikey42979 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-20-2014, 03:15 PM
  4. Converting Pipe Delimited Data String into Seperate columns using VBA Macro
    By RestlessNative in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-06-2014, 05:40 PM
  5. [SOLVED] Converting a column of text data by assigning numbers to each type of response
    By westicles in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-27-2013, 10:26 PM
  6. Converting Text to Date - delimited format ?
    By Blewyn in forum Excel General
    Replies: 10
    Last Post: 12-24-2006, 07:50 AM
  7. [SOLVED] Converting Excel data into semicolon delimited text file
    By danmcgov in forum Excel General
    Replies: 1
    Last Post: 04-14-2005, 12:06 PM

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