I understand the first example.. bit a little confused on the second.. where is the 'OH' coming from..?
Try this quickie hack.. assuming your data starts in the first column, first cell A1, and goes down..
=UPPER(LEFT(A1,2)&MID(A1,SEARCH(" ",A1,3)+1,2)&MID(A1,SEARCH(", ",A1,3)+2,2))
explained:
Get the first 2 characters from the left..
Find the position of the first space, and grab the next two characters.. and append..
Find the comma followed by a space, and grab the next two characters.. and append...
Lather, rinse, repeat..
|