Trim first word in cell

Hi gentlemen,

I would like to ask,

If i have column F, each row has 1 code in cell (different length), but sometimes after this code is many spaces and some other words or codes...

How to left only first world in cell by macro ?

thanks

xbr088,

Something like this should work for you:

Please Login or Register  to view this content.

What separates the code from the rest of the cell contents?

Is it a space?

The code I provided is a sample to show you how to get what you requested. You need to apply it to your current code. I imagine you have a loop setup already that goes through column F. If you don't, here is some more example code:

Please Login or Register  to view this content.

Hmm, small confusing. i tried both of your codes. and both made same. Extract first word and shows me in popup window. That's great, but after i close this popup, everything stay same, nothing is trimmed. Where i made fault ?

Sorry for my dummy question But i need only keep first word in all row's cells in F column, and all others to delete (means others spaces, words)

Oh, you want to replace what is in column F with the codes that get retrieved, you can do that like so:

Please Login or Register  to view this content.

Here's an alternate way to do the same thing, but it would be harder to edit and is probably not very easy to follow/understand:

Please Login or Register  to view this content.