Activecell.offset(0,1).Value = "0000-0000-000-000-"

--
Regards,
Tom Ogilvy

"childothe1980s" wrote in message
...
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