Thread: text to columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bwduncan bwduncan is offline
external usenet poster
 
Posts: 1
Default text to columns

I've exported a worksheet that put are customer id # and name in the same
column.
Of course our customer id aren't all the same length and some of the names
also have a "-" in them. Is there a way to seperate this by the first hyphen
only and to disregard the second one?