Loop and Trim based on condition

[SWMagic]

Hi:

I've got a column that I'd like to loop to the end, and if the value of the text in that cell starts with an A or number, I want to strip out everything except the first 10 characters.

How would I do that?

Thanks, Paul

[zbor]

Here, try this:

[DonkeyOte]

Formula wise - based on zbor's file - perhaps:

=LEFT(A1,IF(OR(LEFT(A1)="a",ISNUMBER(--LEFT(A1))),10,LEN(A1)))

If you want a VBA routine to replace the originals then you could use something like:

Please Login or Register  to view this content.

[SWMagic]

Zbor and DonkeyOte.

Wow. That worked great. Thanks, it is much appreciated!

[SWMagic]

Oops wanted new thread!

[SWMagic]

Well this is embarrassing. New Post doesn't really mean that does it...

[zbor]

New post doesn't really mean that does New thread