Title: Replace blank fields
Last modified: September 26, 2019

---

# Replace blank fields

 *  Resolved [earlymath](https://wordpress.org/support/users/earlymath/)
 * (@earlymath)
 * [6 years, 8 months ago](https://wordpress.org/support/topic/replace-blank-fields/)
 * I just purchased the Sheet Editor wordpress plugin. My question is, I want to
   replace hundreds of users role with “subscriber” that currently have roles that
   are blank fields. Of course, ignoring any users that have “administrator” or “
   editor” or any other roles. You have the replace option, but I don’t see a way
   to replace blank fields. Is there a particular syntax I could use to replace 
   blank role fields with “subscriber”?

Viewing 1 replies (of 1 total)

 *  Plugin Author [Jose Vega](https://wordpress.org/support/users/josevega/)
 * (@josevega)
 * [6 years, 8 months ago](https://wordpress.org/support/topic/replace-blank-fields/#post-11973057)
 * Hi. You can follow [this tutorial](https://wpsheeteditor.com/wordpress-find-users-without-role-assign-role-in-seconds/)

Viewing 1 replies (of 1 total)

The topic ‘Replace blank fields’ is closed to new replies.

 * ![](https://ps.w.org/wp-sheet-editor-bulk-spreadsheet-editor-for-posts-and-pages/
   assets/icon-256x256.png?rev=1543619)
 * [Bulk Edit Posts and Products in Spreadsheet](https://wordpress.org/plugins/wp-sheet-editor-bulk-spreadsheet-editor-for-posts-and-pages/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-sheet-editor-bulk-spreadsheet-editor-for-posts-and-pages/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-sheet-editor-bulk-spreadsheet-editor-for-posts-and-pages/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-sheet-editor-bulk-spreadsheet-editor-for-posts-and-pages/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-sheet-editor-bulk-spreadsheet-editor-for-posts-and-pages/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-sheet-editor-bulk-spreadsheet-editor-for-posts-and-pages/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Jose Vega](https://wordpress.org/support/users/josevega/)
 * Last activity: [6 years, 8 months ago](https://wordpress.org/support/topic/replace-blank-fields/#post-11973057)
 * Status: resolved