Remove single text characters
 

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)
.