When I try to use the following option "Text to Columns" -> "Delimited" -> "Other" box, Excel will not let me type anything into the box.  I just hear a ping sound, like when I'm not allowed to do something.  Does anyone know why I cannot enter anything into the box?

I actually figured out my problem.

I was trying to use the delimiter on a return character, so I was typing CTRL+J into the "Other" box.  It would put the return character into the box, but I would not see it.  Once I hit "Delete" the return character was gone, and the box would work normally.

I made the mistake of opening a new workbook inside the same application of Excel, the return character would carry over to the new workbook's Text to Columns tool.  So it seemed like that box would not work when I typed a character into it, because the return character was still in that box, but I did not see it.

• Marked as answer by John Rutledge 11 hours 10 minutes ago
• Edited by John Rutledge 11 hours 9 minutes ago

I actually figured out my problem.

I was trying to use the delimiter on a return character, so I was typing CTRL+J into the "Other" box.  It would put the return character into the box, but I would not see it.  Once I hit "Delete" the return character was gone, and the box would work normally.

I made the mistake of opening a new workbook inside the same application of Excel, the return character would carry over to the new workbook's Text to Columns tool.  So it seemed like that box would not work when I typed a character into it, because the return character was still in that box, but I did not see it.

• Marked as answer by John Rutledge Monday, May 18, 2015 8:17 PM
• Edited by John Rutledge Monday, May 18, 2015 8:19 PM

Hi,

Thanks for visiting our forum and sharing your experience here. It'll be benefited to our communicator.

Have a good time.

Regards,

George Zhao
TechNet Community Support