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.
Bookmarks