Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
carl
 
Posts: n/a
Default Removing "Spaces" Entire Workbook

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

Thank you in advance.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bearacade
 
Posts: n/a
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo
 
Posts: n/a
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How many queries are there in my entire Excel workbook? sjp209 Excel Discussion (Misc queries) 1 April 18th 06 06:14 PM
Set 'Print Entire Workbook' as default? Mike Excel Discussion (Misc queries) 0 April 5th 06 09:23 PM
Search Entire Workbook Sloth Excel Discussion (Misc queries) 0 October 14th 05 05:12 AM
Setup Entire Workbook to print all tabs Duplex John Jr. Excel Worksheet Functions 1 August 4th 05 06:46 PM
Excel should let me set the print default to "Entire Workbook". GSL Setting up and Configuration of Excel 1 February 7th 05 08:03 PM


All times are GMT +1. The time now is 08:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"