LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
bvinternet
 
Posts: n/a
Default How do I find cells that being with a blank?


::Hi,
I have a spreadsheet with circa 11,000 rows, approx. 6 columns.
Some of the data MAY contain values that begin with a blank space,
e.g. the cell may look like (ignore quotes)

\" Fred\"

when it should be

\"Fred\"

Is there an easy way to change the cell colour to Red for all cells in
a spreadsheet where the first character is blank ?

Thanks in advance for your kind help.

Matt::


--
bvinternet
------------------------------------------------------------------------
bvinternet's Profile: http://www.excelforum.com/member.php...o&userid=25525
View this thread: http://www.excelforum.com/showthread...hreadid=389620

 
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
Skip blank cells in diagrams hlp Charts and Charting in Excel 9 February 24th 06 02:32 PM
Copy down - special to fill only the blank cells Mike Excel Discussion (Misc queries) 3 April 18th 05 10:08 PM
What function can make cells shift up when they are blank? Julie Excel Worksheet Functions 0 March 26th 05 07:31 PM
how do you ignore blank cells in formulas Kerry Excel Discussion (Misc queries) 2 February 16th 05 01:56 PM
Blank cells? David Excel Worksheet Functions 7 February 3rd 05 07:49 AM


All times are GMT +1. The time now is 06:04 PM.

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

About Us

"It's about Microsoft Excel"