View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
 
Posts: 622
Default how to limit amount of numbers in cells in excel

On Aug 20, 8:13 am, Challenger
wrote:
How do I remove the delimiter? How are you typing the vertical line character?



If you use Text to Columns, whatever delimiter you use will vanish.
You can use more than one, if you need a space or comma to separate
some columns, too. Otherwise, the formula I wrote before will get rid
of it and put in whatever text you want.

It's simple to type, surprisingly, but sorta hidden. The bar is
usually right above the Return/Enter button on a USA keyboard. It is
pictured as a broken line, but Windows actually types the solid line.
aka SHIFT-backslash.