Removing "Spaces" Entire Workbook
 

Is it possible to remove all " " - spaces in all worksheets in an open
workbook.

Thank you in advance.

Removing "Spaces" Entire Workbook
 

Highlight all your worksheets, by clicking on the first sheet and
shift-clicking on the last sheet.

Press Control H
in Find what just put a space in it
and press Replace all


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=549027

Removing "Spaces" Entire Workbook
 

spaces between texts?

regards

"carl" escreveu:

Is it possible to remove all " " - spaces in all worksheets in an open
workbook.

Thank you in advance.