| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove character at end of data
I have a column of data in the form of 1-1, 1-2, … 1-123, it has a space at
the end of the numbers, not really a space, I can copy the "space" and paste it in another cell and then use = code and I get a code of 160. how can I get this out from behind all the data in column B. I have copied the "space" and did a replace on the column but then all the cells format as a date, even if I format the column to text first. How can I do this and not have the data change to a date? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove data that preceeds a character | Excel Worksheet Functions | |||
| How to remove character format under .csv? | Excel Discussion (Misc queries) | |||
| Remove ' character from copied excel cell to match data | Excel Discussion (Misc queries) | |||
| Remove character from imported data | Excel Discussion (Misc queries) | |||
| How to remove a character from the first index? | Excel Discussion (Misc queries) | |||
![Paul B[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
