V VW May 13, 2004 #1 Does anyone know how find a row in a worksheet which contains carriage return character (usually a square) in its cell ?
Does anyone know how find a row in a worksheet which contains carriage return character (usually a square) in its cell ?
M Max May 13, 2004 #2 I've given you the response below yesterday to your post, re: http://tinyurl.com/2esbm -------- Maybe CHAR(10) ? (carriage return via Alt + Enter) Assume you want to check range A1:C10 in Sheet1 for cells with carriage return In a new Sheet2: Put in A1: =IF(ISERROR(SEARCH(CHAR(10),Sheet1!A1)),"","Yes") Copy A1 across to C1, then down to C10 to cover the same range as in Sheet1 A1:C10 in Sheet2 will return "Yes" for corresponding cells with carriage returns in range A1:C10 in Sheet1
I've given you the response below yesterday to your post, re: http://tinyurl.com/2esbm -------- Maybe CHAR(10) ? (carriage return via Alt + Enter) Assume you want to check range A1:C10 in Sheet1 for cells with carriage return In a new Sheet2: Put in A1: =IF(ISERROR(SEARCH(CHAR(10),Sheet1!A1)),"","Yes") Copy A1 across to C1, then down to C10 to cover the same range as in Sheet1 A1:C10 in Sheet2 will return "Yes" for corresponding cells with carriage returns in range A1:C10 in Sheet1
