REMOVE SINGLE TEXT CHARACTERS IN A CELL (JOHN C AND LINDA Q)
REMOVE SINGLE TEXT CHARACTERS IN A CELL (JOHN C AND LINDA Q)
Here one way, but probably not the quickest:
1. With your values in column A, put this in B1 and copy
down:
=" "&A1&" "
2. Now copy column B, select col. A, and go to Edit >
Paste Special > Value.
3. Press ESC and then press Ctrl+H.
4. In the "Find What" box put <space>?<space>
and "Replace With" <space>. Don't actual key in th word
<space>, just hit your spacebar. Select "Replace All"
5. Now repace the formula from step 1 with =TRIM(A1),
fill down, and paste special > value the column over
itself.
HTH
Jason
Atlanta, GA
>-----Original Message-----
>REMOVE SINGLE TEXT CHARACTERS IN A CELL (JOHN C AND
LINDA Q)
>.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks