Using IF to recognize data then Remove characters

[Sphinx404]

I am trying to create a function that will recognize data beginning with "006"

If it finds data beginning with "006" then remove all but the last 8 characters

I don't know why I am having such a hard time with this one.

Something like:

=IF(LEFT(A1,3)="006"(RIGHT,A1,LEN(A1)-8)

Thank you in advance for your help.

 

[Joe4]

If you just want the last 8 characters, then simply try:

[COLOR=#333333]=IF(LEFT(A1,3)="006",RIGHT(A1,8),"")[/COLOR]

 

[Rick Rothstein]

I am trying to create a function that will recognize data beginning with "006"

If it finds data beginning with "006" then remove all but the last 8 characters

I don't know why I am having such a hard time with this one.

Something like:

=IF(LEFT(A1,3)="006"(RIGHT,A1,LEN(A1)-8)

Does this work for you...

=IF(LEFT(A1,3)="006",RIGHT(A1,8),"")

 

[Sphinx404]

Oh dear lord thank you! I knew it was simple... I've been racking my brain on this simple function for half an hour... Oh Friday work day, please end swiftly.

THANK YOU!!!!