Thread: Doing this in Excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
GS[_2_] GS[_2_] is offline
external usenet poster
  
Posts: 3,514
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.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


Reply With QuoteReply With Quote