| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting spaces in blank cells
Try using TRIM to remove extraneous spaces
Eg, in B1, copied down: =TRIM(A1) Then if required, copy col B and overwrite col A with a paste special as values. Then delete col B -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "scubadiver" wrote: I have some records which have blank cells that contain spaces. How can I delete these spaces without deleting spaces in other cells which contain information. Does this make sense? thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting blank spaces in cells | Excel Discussion (Misc queries) | |||
| Fill blank cells with spaces | Excel Worksheet Functions | |||
| Deleting Blank Cells Wholesale? | Excel Discussion (Misc queries) | |||
| Deleting blank cells in a column | Excel Discussion (Misc queries) | |||
| Deleting rows with blank cells | Excel Worksheet Functions | |||
Threaded Mode
