View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
childothe1980s childothe1980s is offline
external usenet poster
 
Posts: 23
Default deleting the apostrophe

Hello:

In a column of Excel cells, I have the following character mask:

0000-0000-000-000-

The first character has an apostrophe in front of it. I want to create a
column to the right that has these characters and in the above format but
without the apostrophe that appears at the beginning.

What formula can I use to accomplish this?

Thanks!

childofhte1980s