Hello,
I have a cell value that I am unable to modify.
Cell A1 = Ｄ３８９９９ï¼�ï¼’ï¼�ＫＨ５３ＳＡ w/font "ï¼*ï¼³ Ｐゴシック" (a font not installed in the
system)
Cell B1 = D38999/26FA35PN w/font "Arial 10pt"

I want to split A1's cell by using the "/" as a delimiter and change the
font. B1 reacts normally to changes, A1 won't react to my changes. Also,
Edit-Replace doesn't work on the "/". Changing the font doesn't work.
Clearing formats won't work. A1 is not locked and the sheet is not
protected. Hmm, tis a mystery!

Thank you for your help,
Terri

Select A1, in the formula bar highlight the weird slash and copy it,
do text to columns and as delimiter select other and paste it into the box,
now you will get a weird view where it looks like the delimiter is in
bewteen the first two 9s but when you click finish it will be alright
You might want to do this on a copy of your sheet


--

Regards,

Peo Sjoblom

"Terri" wrote in message
...
Hello,
I have a cell value that I am unable to modify.
Cell A1 = D38999/20KH53SA w/font "MS P????" (a font not installed in the
system)
Cell B1 = D38999/26FA35PN w/font "Arial 10pt"

I want to split A1's cell by using the "/" as a delimiter and change the
font. B1 reacts normally to changes, A1 won't react to my changes. Also,
Edit-Replace doesn't work on the "/". Changing the font doesn't work.
Clearing formats won't work. A1 is not locked and the sheet is not
protected. Hmm, tis a mystery!

Thank you for your help,
Terri

Wow...your idea worked great to split the cell content. Thank you! How can
I change the appearance by changing the font?

"Peo Sjoblom" wrote:

Select A1, in the formula bar highlight the weird slash and copy it,
do text to columns and as delimiter select other and paste it into the box,
now you will get a weird view where it looks like the delimiter is in
bewteen the first two 9s but when you click finish it will be alright
You might want to do this on a copy of your sheet


--

Regards,

Peo Sjoblom

"Terri" wrote in message
...
Hello,
I have a cell value that I am unable to modify.
Cell A1 = D38999/20KH53SA w/font "MS P????" (a font not installed in the
system)
Cell B1 = D38999/26FA35PN w/font "Arial 10pt"

I want to split A1's cell by using the "/" as a delimiter and change the
font. B1 reacts normally to changes, A1 won't react to my changes. Also,
Edit-Replace doesn't work on the "/". Changing the font doesn't work.
Clearing formats won't work. A1 is not locked and the sheet is not
protected. Hmm, tis a mystery!

Thank you for your help,
Terri

What happens when you change the font?


"Terri" wrote:

Hello,
I have a cell value that I am unable to modify.
Cell A1 = Ｄ３８９９９ï¼�ï¼’ï¼�ＫＨ５３ＳＡ w/font "ï¼*ï¼³ Ｐゴシック" (a font not installed in the
system)
Cell B1 = D38999/26FA35PN w/font "Arial 10pt"

I want to split A1's cell by using the "/" as a delimiter and change the
font. B1 reacts normally to changes, A1 won't react to my changes. Also,
Edit-Replace doesn't work on the "/". Changing the font doesn't work.
Clearing formats won't work. A1 is not locked and the sheet is not
protected. Hmm, tis a mystery!

Thank you for your help,
Terri

The font looks the same as the original, I can't see any difference.

"Duke Carey" wrote:

What happens when you change the font?


"Terri" wrote:

Hello,
I have a cell value that I am unable to modify.
Cell A1 = Ｄ３８９９９ï¼�ï¼’ï¼�ＫＨ５３ＳＡ w/font "ï¼*ï¼³ Ｐゴシック" (a font not installed in the
system)
Cell B1 = D38999/26FA35PN w/font "Arial 10pt"

I want to split A1's cell by using the "/" as a delimiter and change the
font. B1 reacts normally to changes, A1 won't react to my changes. Also,
Edit-Replace doesn't work on the "/". Changing the font doesn't work.
Clearing formats won't work. A1 is not locked and the sheet is not
protected. Hmm, tis a mystery!

Thank you for your help,
Terri