Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
removing extra spaces | Excel Discussion (Misc queries) | |||
Removing Spaces | Excel Discussion (Misc queries) | |||
removing all spaces | Excel Discussion (Misc queries) | |||
Removing spaces from value using VBA | Excel Programming | |||
removing spaces | Excel Discussion (Misc queries) |