Microsoft Office Forums Delete Blank Rows (Cyrillic Text in Spreadsheet )

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-29-2013, 08:16 AM
dozd dozd is offline Delete Blank Rows (Cyrillic Text in Spreadsheet ) Windows 7 32bit Delete Blank Rows (Cyrillic Text in Spreadsheet ) Office 2010 32bit
Novice
Delete Blank Rows (Cyrillic Text in Spreadsheet )
 
Join Date: Jan 2013
Posts: 1
dozd is on a distinguished road
Default Delete Blank Rows (Cyrillic Text in Spreadsheet )

Hi, I wanted to Delete Blank Rows in SHeet, and found this solution:



http://chandoo.org/wp/2010/01/26/del...nk-rows-excel/

It works fine but only if I use text with Latin Alphabet in spreadsheet. With Cyrillic text in spreadsheet it does not work. I receive error "No cells were found" when I try to select blank cells (CTRL+G ->Special->Blank-> OK)


Can anybody help me to use this solution with Cyrillic Alphabet?

thanks for understanding
Reply With Quote
  #2  
Old 02-22-2013, 03:24 AM
macropod's Avatar
macropod macropod is offline Delete Blank Rows (Cyrillic Text in Spreadsheet ) Windows 7 64bit Delete Blank Rows (Cyrillic Text in Spreadsheet ) Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,483
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Hi dozd,

Are you sure the cells are actually empty and don't contain spaces or hidden content (eg 0s hidden via formatting)?

If so, can you attach a document to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete Blank Rows (Cyrillic Text in Spreadsheet ) Count rows and add blank rows accordingly Hoochtheseal Word VBA 1 01-29-2013 09:23 PM
Delete Blank Rows (Cyrillic Text in Spreadsheet ) Delete all rows but the last. elky1967 Word VBA 14 09-21-2012 05:27 AM
Delete Blank Rows (Cyrillic Text in Spreadsheet ) Macro to conditionally delete rows Steve_D Excel 2 08-24-2012 09:37 PM
Delete Blank Rows (Cyrillic Text in Spreadsheet ) Macro to delete rows with all empty cells ubns Excel Programming 2 08-14-2012 02:01 AM
Delete Blank Rows (Cyrillic Text in Spreadsheet ) How to remove blank rows from a specified range? Learner7 Excel 1 04-19-2011 02:45 AM


All times are GMT -7. The time now is 06:55 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft