G
Guest
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
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