XXXXXXXX XXXXXXX0001 0010001-XXXX--XXXXXXX.
XXX XXXXX
X 010001Z XXX 06
FM ORIGINATOR
TO RHHIABC/UNIT 1
RHHIDEF/UNIT 2
RHHIABC/UNIT 3
RHHIABC/UNIT 4
RHHIABC/UNIT 5
RHHIDEF/UNIT 6
RHHIABC/UNIT 7
RHHIABC/UNIT 8
RHHIDEF/UNIT 9
RHHIABC/UNIT 10
RHHIABC/UNIT 11
RHHIDEF/UNIT 12
RHHIABC/UNIT 13
RHHIGHI/UNIT 14
RHHIABC/UNIT 15
RHHIABC/UNIT 16
RHHIGHI/UNIT 17
RHHIABC/UNIT 18
RHHIABC/UNIT 19
RHHIGHI/UNIT 20
RHHIABC/UNIT 21
RHHIABC/UNIT 22
RHHIGJO/UNIT 23
RHHIABC/UNIT 24
RHHIABC/UNIT 25
RHHIDEF/UNIT 26
RHHIABC/UNIT 27
SUBJ/TEST//
REMARKS/THIS IS A TEST MESSAGE. NO ACTION REQUIRED.//
END OF MESSAGE
NNNN

*Using your delete macro, I can delete the header/footer info and just have the "Unit" info in the routing indicator(RHHI***)/unit name format.

Now, I'm trying to use something similar to the "text to columns" function to separate the routing indicator (RHHI***) and unit name into two different columns.

That will lead to the final step of sorting each unit into a specific category based on routing indicator, but only the Unit name will appear...(all of it is just regular .txt data - I have the formula to do this thanks to xld)

Hope this helps (I don't have the worksheet on this machine or I would post it)