Thread: What formula do I use to copy only text on left side of a comma?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Danielsjt Danielsjt is offline
external usenet poster
  
Posts: 1
Default What formula do I use to copy only text on left side of a comma?
I have a spreadsheet and in column D contains Equipment #'s and their
description separated by a comma. How can I separate the Equipment #'s into
Column G.
Sheet contains approx. 1500 rows.

Example:
T-8900-F, Fresh Water storage Tank

Reply With QuoteReply With Quote