VBA Left function

[Borg]

Hello,

I am trying to use the left function to include only the first account number, for example if a cell has "120122 280000" (there may be many spaces between the two numbers), I only want 120122. So far my programming only returns the 280000 into the cell.

Here is my programming so far, hope someone can help me ou. I am working with cell values in column "K".

Please Login or Register  to view this content.

[DonkeyOte]

Couldn't you simply run an Edit Replace replacing: [space]* with nothing ?

As for the code - I can't see how you're returning 280000 based on your sample.... could you post a sample ?

[shg]

Try this:

Please Login or Register  to view this content.

[Borg]

Couldn't you simply run an Edit Replace replacing: [space]* with nothing ?

As for the code - I can't see how you're returning 280000 based on your sample.... could you post a sample ?

Here is an example.

[Borg]

Try this:

Please Login or Register  to view this content.

It still seems the same. I'm kind of a noob with VBA.

[shg]

Runs fine for me in your workbook.

If you need to preserve the leading zeros then

Please Login or Register  to view this content.

[Borg]

Okay, thanks. It works, I confused myself.