Thursday, April 05, 2007

Excel Tip - Removing characters from a cell

Since I have remove characters off cells every so often in Excel, I always forget. I always have to Google my answer.

In Excel my cell contains data like this in cell A1
marker lat="37.5002273543" lng="-79.1252303123" found="-79.12523031234741" left="37.500227354254726"

But I don't need the duplicate longitude and latitude coordinates. So I write a formula that can do this.
=LEFT(A1, LEN(A1)-48)
That will chop off the last 48 characters. You can also do the right side and chop off the first set of characters. And I'm sure some can write a formula that can count from the left and chop off anything after that. But that is my method (madness I tell ya)

No comments: