using XL 2003. Thanks!! ....Lisa
P Pete_UK Jul 25, 2007 #2 If you want to get rid of the rightmost 4 characters from cell A1, for example, use this: =LEFT(A1,LEN(A1)-4) Hope this helps. Pete
If you want to get rid of the rightmost 4 characters from cell A1, for example, use this: =LEFT(A1,LEN(A1)-4) Hope this helps. Pete
G gerry.lisa Jul 25, 2007 #3 That did it...thanks!! ....Lisa If you want to get rid of the rightmost 4 characters from cell A1, for example, use this: =LEFT(A1,LEN(A1)-4) Hope this helps. Pete - Show quoted text - Click to expand...
That did it...thanks!! ....Lisa If you want to get rid of the rightmost 4 characters from cell A1, for example, use this: =LEFT(A1,LEN(A1)-4) Hope this helps. Pete - Show quoted text - Click to expand...
P Pete_UK Jul 25, 2007 #4 You're welcome - thanks for feeding back. Pete That did it...thanks!! ...Lisa - Show quoted text - Click to expand...
You're welcome - thanks for feeding back. Pete That did it...thanks!! ...Lisa - Show quoted text - Click to expand...
