Doing this in Excel?
If your list starts in A1...
In B1 enter
=MID($A1,2,LEN($A1)-1)
and copy down as needed
Another way to do this...
=REPLACE(A1,1,1,"")
Note: If you are copying down, there is no need to make the column reference
absolute.
Rick Rothstein (MVP - Excel)
|