View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pat[_4_] Pat[_4_] is offline
external usenet poster
 
Posts: 6
Default Highlight cells where the last charcter in the cell is a blank

Hi All,

If anyone knows the answer to this one without putting themselves out,
I would be very grateful.

I have a load of entries in column A (A1:A2000) and some of the cells
contain a blank character at the end.

Just wondering if those cells with a blank character as the last
character can be highlighted by running a formula or macro?

Many thanks in advance,

Cheers,

Pat