| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing characters
Select column containing data and choose data text to columns twice.
-First time just click finish (assuming tab delimited) -Second time click Next Next and select Text to convert back to text |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing characters from a cell (keeping only the numbers) | Excel Discussion (Misc queries) | |||
| Removing characters from a cell (keeping only numbers) 2 | Excel Discussion (Misc queries) | |||
| Removing unwanted characters | Excel Discussion (Misc queries) | |||
| removing pre-set characters from comments | Excel Worksheet Functions | |||
| Removing Non-Numeric Characters | Excel Discussion (Misc queries) | |||
Threaded Mode
