View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default 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)