View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rony[_2_] Rony[_2_] is offline
external usenet poster
 
Posts: 2
Default Removing Everything behing 3 Spaces

Hello,

I hope somebody can help me with this.
I have a colum and in that colum are differect cells with text. Example

OPTERON 250 2.4GHZ FSB1000 CHIP

Like you see there are a fex spaces and the nthe word CHIP.
I'm looking for a code finding that is scanning the row (In this case Row.C)
Finding the cells containing the three spaces and removing everything
followed after the spaces.

The final result will be

OPTERON 250 2.4GHZ FSB1000

Is there anyway to fix this?

Thanks already for all your help!
Rony