Thread: How do I truncate something like this?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How do I truncate something like this?
You could try DataText to ColumnsDelimited by "-"


Gord Dibben MS Excel MVP

On Sat, 30 Dec 2006 09:20:50 -0600, ckeys wrote:

I have a column with text like

BRAND X - version 1
BRAND X - version 2.4
BRAND Y - version 3D
BRAND Y - version 8C
BRAND Y - version 3.5.6
BRAND Z - version 5X

and so on. It's very long spreadsheet. I'd like to chop off the
version info (which is of varying length) and group everything
together by just the brand name. How do I do this?

Thanks for any input.

Reply With QuoteReply With Quote