G gerry.lisa Aug 13, 2007 #1 XL 2003 the number of characters to the left of the ":" will vary ....Lisa
R Rick Rothstein \(MVP - VB\) Aug 13, 2007 #3 XL 2003 the number of characters to the left of the ":" will vary Click to expand... This will leave the colon and remove everything after it... =LEFT(A20,FIND(":",A20)) This will remove the colon also... =LEFT(A20,FIND(":",A20)-1) Rick
XL 2003 the number of characters to the left of the ":" will vary Click to expand... This will leave the colon and remove everything after it... =LEFT(A20,FIND(":",A20)) This will remove the colon also... =LEFT(A20,FIND(":",A20)-1) Rick
G gerry.lisa Aug 13, 2007 #4 This will leave the colon and remove everything after it... =LEFT(A20,FIND(":",A20)) This will remove the colon also... =LEFT(A20,FIND(":",A20)-1) Rick Click to expand... Thank you!!! ....Lisa
This will leave the colon and remove everything after it... =LEFT(A20,FIND(":",A20)) This will remove the colon also... =LEFT(A20,FIND(":",A20)-1) Rick Click to expand... Thank you!!! ....Lisa
