Thread: Macro which delets in a cell all characters after comma
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
andrei[_19_] andrei[_19_] is offline
external usenet poster
  
Posts: 1
Default Macro which delets in a cell all characters after comma

Hi guys !

I have a lot of cells with text , empty spaces etc . All cells contain
a "," (comma) . I need a macro that delets all after that comma ,
including comma . I give in example :

A1 : mother, father

The result should be :

A1 : mother

Many thanks !


--
andrei
------------------------------------------------------------------------
andrei's Profile: 1056
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=193313

http://www.thecodecage.com/forumz

Reply With QuoteReply With Quote