No sure what is meant by 'recognized'
=LEFT(A1,5)
=RIGHT(A1,2)
=MID(A1,1,5)
=SUBSTITUTE(A1,"AA","--")
Any help?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"addie" wrote in
message ...

Is there a formula that would recognize and omit specific characters
within a field?

Example:

Data Field has the following 9 characters "R0502AA01".

Only the following 7 characters: "R0502--01" should be picked up or
recognized.

What formula will pick up the 1st-5th and the 8th-9th characters and
bypass the 6th & 7th characters?

Addie


--
addie
------------------------------------------------------------------------
addie's Profile:
http://www.excelforum.com/member.php...o&userid=25526
View this thread: http://www.excelforum.com/showthread...hreadid=513674