Formula Needed to Omit Characters




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?action=getinfo&userid=25526
View this thread: http://www.excelforum.com/showthread.php?threadid=513674

.