Link to home
Create AccountLog in
Avatar of John Carney
John CarneyFlag for United States of America

asked on

Macro or function that will parse an alphanumeric string and reconstruct and distribute it.

I doubt that I phrased the question properly, butI need a macro or function that will look at a range of cells, and when it finds a value like this:
42CDEF
it will parse and reconstruct and distribute the results to other cells like this:
42C    42D    42E    42F
It will ignore substrings that have only one letter after the number.
3ABC, 5D, 17DF will produce:
3A    3B   3C    17D    17F

The number can be anywhere from 1 to 3 characters, but it will always be at the start of the string.

Thanks!
John
Avatar of Ray Paseur
Ray Paseur
Flag of United States of America image

What is the source of the data?  It looks like it may have had a taxonomy at one time, but the structure has been removed?
ASKER CERTIFIED SOLUTION
Avatar of Ray Paseur
Ray Paseur
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of John Carney

ASKER

Hi Ray, I'm sorry ...  I have ther question in the wrong area, it should be Excel/VBA. but it will be very interesting to learn how to do something like this PHP, so I think I'll acceptthis answer and then re-post the question in the right zone.

Thanks,
John
Ha!  Thanks for the points, and Happy New Year, ~Ray