| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Problems
In Cell A1 - testing_____ << _ underscore is actually blanks
B1 - =Len(A1) << = 12 C1 =Trim(A1) << = testing D1 = Len(C1) << = 7 Copy C1 (only) and without moving the cursor Edit, Paste-Special - select check Value box; OK Write back if problem.. wrote in message ups.com... I'm in excel and I have a bunch of text data that has an extra space at the end of the text on the right hand side for each cell. Is there any easy way to remove this space? I've tried using the trim function, but when I do this and use copy-paste special-values, there is still a space in my result. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting datetime problems importing data from mysql db | Excel Discussion (Misc queries) | |||
| cell formatting problems | Excel Discussion (Misc queries) | |||
| cell formatting problems | New Users to Excel | |||
| Problems with cell formatting | Excel Discussion (Misc queries) | |||
| Formatting problems | Excel Discussion (Misc queries) | |||
Threaded Mode
