| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove leading spaces from excel worksheet
Sandy thanks for this, works a treat.
Regards Chris "Sandy" wrote: Replace "Selection" with your range ie Range("A1:D100") ir26121973 wrote: Thanks for this Sandy. Where would I put in a specific range as the spreadsheet does have quite a lot of information in. Thanks Chris "Sandy" wrote: Try this: just highlight the cell you want checked and run the macro Sub RemoveSpaces() Dim MyCell As Object For Each MyCell In Selection MyCell.Value = Trim(MyCell) Next MyCell End Sub Sandy ir26121973 wrote: Hi, Wonder if somone can help me please. I have a spreadsheet with a number of cells that are blank to look at but have a space in them as the first character. Can someone tell me please how to write a macro that within a given range looks at the cells that look blank and have the first character as a space and then remove that space. Many thanks Chris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you remove leading spaces etc in cells? | New Users to Excel | |||
| remove leading spaces | Excel Worksheet Functions | |||
| how do I remove leading spaces and leave the remianing spaces w | Excel Worksheet Functions | |||
| VBA help please - remove leading spaces | Excel Programming | |||
| Remove Leading Spaces | Excel Discussion (Misc queries) | |||
Threaded Mode
