D DubboPete Feb 2, 2010 #1 Is this easy to do? The last seven characters are constants, I just want what precedes them... DubboPete
Is this easy to do? The last seven characters are constants, I just want what precedes them... DubboPete
D DubboPete Feb 2, 2010 #3 give this a try =MID(A1,1,LEN(A1)-7) -- Gary Keramidas Excel 2003 - Show quoted text - Click to expand... Just the ticket, thanks Gary!
give this a try =MID(A1,1,LEN(A1)-7) -- Gary Keramidas Excel 2003 - Show quoted text - Click to expand... Just the ticket, thanks Gary!
