All posts by Ablebits.com

17Jun/19
ablebits-com-split-names-add-on-for-google-sheets-lifetime-subscription.png

Full Split Names add on for Google Sheets Lifetime subscription

Quickly split full names to several columns with first middle last names titles andor postnominal letters If you ever need to have first and last names in different columns this addon will prove to be a great assistant You can complete this task in a click choose the name parts you need and click Split to have them pulled out to separate cells Thats it The addon recognizes over titles and postnominals you can be sure you address people appropriately Once you start it youll see how simple it is to divide the names Select your column with full names Start the addon and pick the parts you have titles name parts and postnominal letters Click Split and see new columns with the results The addon will insert columns with the selected name units next to the original one  You can keep your table structure by considering or ignoring headers   Run this addon to divide multipart names into separate columns they belong to first middle and last names titles and postnominal letters Splitting names is that easy

Get Split Names add on for Google Sheets Lifetime subscription now:

[sociallocker]Try Split Names add on for Google Sheets Lifetime subscription free version Split Names add on for Google Sheets Lifetime subscription full version Visit Split Names add on for Google Sheets Lifetime subscription product page [/sociallocker]
17Jun/19
ablebits-com-split-names-add-on-for-google-sheets-12-month-subscription.png

Full Split Names add on for Google Sheets 12 month subscription

Quickly split full names to several columns with first middle last names titles andor postnominal letters If you ever need to have first and last names in different columns this addon will prove to be a great assistant You can complete this task in a click choose the name parts you need and click Split to have them pulled out to separate cells Thats it The addon recognizes over titles and postnominals you can be sure you address people appropriately Once you start it youll see how simple it is to divide the names Select your column with full names Start the addon and pick the parts you have titles name parts and postnominal letters Click Split and see new columns with the results The addon will insert columns with the selected name units next to the original one  You can keep your table structure by considering or ignoring headers   Run this addon to divide multipart names into separate columns they belong to first middle and last names titles and postnominal letters Splitting names is that easy

Get Split Names add on for Google Sheets 12 month subscription now:

[sociallocker]Try Split Names add on for Google Sheets 12 month subscription free version Split Names add on for Google Sheets 12 month subscription full version Visit Split Names add on for Google Sheets 12 month subscription product page [/sociallocker]
17Jun/19
ablebits-com-remove-duplicates-add-on-for-google-sheets-lifetime-subscription.png

Download Remove Duplicates add on for Google Sheets Lifetime subscription

Quickly find duplicates in one sheet or in two columns Move delete or highlight the results This addon comes with two useful wizards One will show how to delete duplicates in Google Sheets in steps the other will quickly compare data from two columns for repeated values Find duplicates or uniques is a quick assistant for Google Sheets remove duplicates in a column or find duplicate rows You are free to include the first occurrences or look for unique entries It lets you choose one of ways you can deal with the results highlight or remove duplicate lines copy or move them to another Google Spreadsheet or clear duplicate entries leaving the cells intact Once you run the addon it will display a summary for the results found in your sheet Use the Compare columns or sheets tool to quickly scan two Google Sheets columns for the same values It will take you five simple steps to compare lists and mark the results with colour or status copy or move them clear repeating cells or remove duplicate rows from your main table The addon offers casesensitive search and additional options for handling empty cells and headers You can use this tool to make your Google Sheets duplicatefree in a flash

Get Remove Duplicates add on for Google Sheets Lifetime subscription now:

[sociallocker]Try Remove Duplicates add on for Google Sheets Lifetime subscription free version Remove Duplicates add on for Google Sheets Lifetime subscription full version Visit Remove Duplicates add on for Google Sheets Lifetime subscription product page [/sociallocker]
17Jun/19
ablebits-com-remove-duplicates-add-on-for-google-sheets-12-month-subscription.png

Free Remove Duplicates add on for Google Sheets 12 month subscription

Quickly find duplicates in one sheet or in two columns Move delete or highlight the results This addon comes with two useful wizards One will show how to delete duplicates in Google Sheets in steps the other will quickly compare data from two columns for repeated values Find duplicates or uniques is a quick assistant for Google Sheets remove duplicates in a column or find duplicate rows You are free to include the first occurrences or look for unique entries It lets you choose one of ways you can deal with the results highlight or remove duplicate lines copy or move them to another Google Spreadsheet or clear duplicate entries leaving the cells intact Once you run the addon it will display a summary for the results found in your sheet Use the Compare columns or sheets tool to quickly scan two Google Sheets columns for the same values It will take you five simple steps to compare lists and mark the results with colour or status copy or move them clear repeating cells or remove duplicate rows from your main table The addon offers casesensitive search and additional options for handling empty cells and headers You can use this tool to make your Google Sheets duplicatefree in a flash

Get Remove Duplicates add on for Google Sheets 12 month subscription now:

[sociallocker]Try Remove Duplicates add on for Google Sheets 12 month subscription free version Remove Duplicates add on for Google Sheets 12 month subscription full version Visit Remove Duplicates add on for Google Sheets 12 month subscription product page [/sociallocker]
17Jun/19
ablebits-com-random-generator-for-google-sheets-lifetime-subscription.png

Best Random Generator for Google Sheets Lifetime subscription

Use this addon to quickly fill a range with random passwords custom values numbers booleans or dates according to your criteria This addon will be at hand whenever you need a random set of data in your sheet Forget about inventing clever passwords this tool will quickly create any number of random strings that meet your requirements All you need is pick a set of characters and choose the length for the generated values The addon is also good at filling your range with workdays or weekends in the selected time period getting unique numbers from the defined range randomizing your custom values or simply putting yesno or truefalse values at random  Create any set of random data in your sheet in three simple steps Select the range you want to fill with random values Choose from types of data to generate integer or real numbers dates booleans custom list values or strings Narrow down the data range or character set and click Generate  This tool will be irreplaceable for completing your spreadsheet with random passwords dates numbers or the data type of your choice

Get Random Generator for Google Sheets Lifetime subscription now:

[sociallocker]Try Random Generator for Google Sheets Lifetime subscription free version Random Generator for Google Sheets Lifetime subscription full version Visit Random Generator for Google Sheets Lifetime subscription product page [/sociallocker]
17Jun/19
ablebits-com-random-generator-for-google-sheets-12-month-subscription.png

Free Random Generator for Google Sheets 12 month subscription

Use this addon to quickly fill a range with random passwords custom values numbers booleans or dates according to your criteria This addon will be at hand whenever you need a random set of data in your sheet Forget about inventing clever passwords this tool will quickly create any number of random strings that meet your requirements All you need is pick a set of characters and choose the length for the generated values The addon is also good at filling your range with workdays or weekends in the selected time period getting unique numbers from the defined range randomizing your custom values or simply putting yesno or truefalse values at random  Create any set of random data in your sheet in three simple steps Select the range you want to fill with random values Choose from types of data to generate integer or real numbers dates booleans custom list values or strings Narrow down the data range or character set and click Generate  This tool will be irreplaceable for completing your spreadsheet with random passwords dates numbers or the data type of your choice

Get Random Generator for Google Sheets 12 month subscription now:

[sociallocker]Try Random Generator for Google Sheets 12 month subscription free version Random Generator for Google Sheets 12 month subscription full version Visit Random Generator for Google Sheets 12 month subscription product page [/sociallocker]
17Jun/19
ablebits-com-power-tools-add-on-for-google-sheets-lifetime-subscription.png

Best Power Tools add on for Google Sheets Lifetime subscription

Power Tools addon cuts the clicks on repeated  tasks and brings features for  organizing and unifying data in Google Sheets   Extra spaces formulas and data in the wrong format are among many of the issues the addon deals with Take advantage of the new smart toolbar with handy assistants insert or delete cells and shift adjacent data change case or swap values Click once to AutoSum numbers in every row or column sum and count cells by color   Search all selected sheets for certain values formulas notes and hyperlinks see a list of found entries export or replace them in a click Get Text to columns feature split values in a column by any delimiter  string or by position Automate some routine tasks add or remove text by position transform formulas change formula reference type export range to XML or JSON Bring order to your sheet delete unwanted characters types of data and clean up formatting Get every needed data tool in one place remove duplicates or bring them to one row compare and merge sheets randomize data and much more   The addon keeps history of the recent operations at hand so that you can quickly reapply a set of actions to a different range You can also star the most frequent features to have access to your favorites at any time   When you import data from different sources or share the same spreadsheet with colleagues it becomes critical to bring it in order in the shortest time possible Even such simple tasks as deleting all notes from your sheet can waste a lot of time Power Tools helps you do this in a click Here is a full list of tasks it performs ➊ Smart toolbar offers a set of oneclick actions Advanced find and replace in all selected sheets Insert cells and shift data down or right Delete cells and shift data up or left AutoSum all numbers in columns or rows Sum by fill and text color Flip values in adjacent cells rows or columns with or without their format Change case Freeze or unfreeze top rows and left columns   Main tool sets group solutions by type ➋ Remove unwanted data Delete leading and trailing spaces Reduce spaces between words to one Remove html entities nonprinting characters and delimiters Get rid of any character or string in the range Delete characters by position or those that follow or precede certain text Remove empty or unused rows and columns ➌ Clear data by type Erase any combination of data types from the selected range formatting numbers dates booleans notes text or hyperlinks  ➍ Work with text Capitalize each cell or word change case to uppercase or lowercase Add your text at the beginning or at the end of the selected cells before or after certain text or at any position you like Replace accented characters with nonaccented turn codes to symbols and back ➎ Convert data format Convert textformatted numbers and dates to numeric and date format Change number sign Export range to JSON or XML ➏ Try out the formula tools Switch formula reference type from relative to absolute or vice versa Get values instead of the formulas Automatically add functions to all selected columns Apply new calculations to all formulas at once ➐ Split tool set Separate values by any character or string Split text by position Extract name parts into separate columns ➑ Data tool set Identify duplicate records in any combination of columns on your sheet Compare two columns or sheets to find duplicates Join values in rows columns or the entire range and keep cells unmerged Merge sheets by a key column Shuffle values in rows columns or the entire range Generate random numbers dates booleans custom lists or strings Combine duplicate rows add subtotals and bring related values together

Get Power Tools add on for Google Sheets Lifetime subscription now:

[sociallocker]Try Power Tools add on for Google Sheets Lifetime subscription free version Power Tools add on for Google Sheets Lifetime subscription full version Visit Power Tools add on for Google Sheets Lifetime subscription product page [/sociallocker]
17Jun/19
ablebits-com-power-tools-add-on-for-google-sheets-12-month-subscription.png

Full Power Tools add on for Google Sheets 12 month subscription

Power Tools addon cuts the clicks on repeated  tasks and brings features for  organizing and unifying data in Google Sheets   Extra spaces formulas and data in the wrong format are among many of the issues the addon deals with Take advantage of the new smart toolbar with handy assistants insert or delete cells and shift adjacent data change case or swap values Click once to AutoSum numbers in every row or column sum and count cells by color   Search all selected sheets for certain values formulas notes and hyperlinks see a list of found entries export or replace them in a click Get Text to columns feature split values in a column by any delimiter  string or by position Automate some routine tasks add or remove text by position transform formulas change formula reference type export range to XML or JSON Bring order to your sheet delete unwanted characters types of data and clean up formatting Get every needed data tool in one place remove duplicates or bring them to one row compare and merge sheets randomize data and much more   The addon keeps history of the recent operations at hand so that you can quickly reapply a set of actions to a different range You can also star the most frequent features to have access to your favorites at any time   When you import data from different sources or share the same spreadsheet with colleagues it becomes critical to bring it in order in the shortest time possible Even such simple tasks as deleting all notes from your sheet can waste a lot of time Power Tools helps you do this in a click Here is a full list of tasks it performs ➊ Smart toolbar offers a set of oneclick actions Advanced find and replace in all selected sheets Insert cells and shift data down or right Delete cells and shift data up or left AutoSum all numbers in columns or rows Sum by fill and text color Flip values in adjacent cells rows or columns with or without their format Change case Freeze or unfreeze top rows and left columns   Main tool sets group solutions by type ➋ Remove unwanted data Delete leading and trailing spaces Reduce spaces between words to one Remove html entities nonprinting characters and delimiters Get rid of any character or string in the range Delete characters by position or those that follow or precede certain text Remove empty or unused rows and columns ➌ Clear data by type Erase any combination of data types from the selected range formatting numbers dates booleans notes text or hyperlinks  ➍ Work with text Capitalize each cell or word change case to uppercase or lowercase Add your text at the beginning or at the end of the selected cells before or after certain text or at any position you like Replace accented characters with nonaccented turn codes to symbols and back ➎ Convert data format Convert textformatted numbers and dates to numeric and date format Change number sign Export range to JSON or XML ➏ Try out the formula tools Switch formula reference type from relative to absolute or vice versa Get values instead of the formulas Automatically add functions to all selected columns Apply new calculations to all formulas at once ➐ Split tool set Separate values by any character or string Split text by position Extract name parts into separate columns ➑ Data tool set Identify duplicate records in any combination of columns on your sheet Compare two columns or sheets to find duplicates Join values in rows columns or the entire range and keep cells unmerged Merge sheets by a key column Shuffle values in rows columns or the entire range Generate random numbers dates booleans custom lists or strings Combine duplicate rows add subtotals and bring related values together

Get Power Tools add on for Google Sheets 12 month subscription now:

[sociallocker]Try Power Tools add on for Google Sheets 12 month subscription free version Power Tools add on for Google Sheets 12 month subscription full version Visit Power Tools add on for Google Sheets 12 month subscription product page [/sociallocker]
17Jun/19
ablebits-com-power-tools-add-on-for-google-sheets-1-month-subscription.png

Full Power Tools add on for Google Sheets 1 month subscription

Power Tools addon cuts the clicks on repeated  tasks and brings features for  organizing and unifying data in Google Sheets   Extra spaces formulas and data in the wrong format are among many of the issues the addon deals with Take advantage of the new smart toolbar with handy assistants insert or delete cells and shift adjacent data change case or swap values Click once to AutoSum numbers in every row or column sum and count cells by color   Search all selected sheets for certain values formulas notes and hyperlinks see a list of found entries export or replace them in a click Get Text to columns feature split values in a column by any delimiter  string or by position Automate some routine tasks add or remove text by position transform formulas change formula reference type export range to XML or JSON Bring order to your sheet delete unwanted characters types of data and clean up formatting Get every needed data tool in one place remove duplicates or bring them to one row compare and merge sheets randomize data and much more   The addon keeps history of the recent operations at hand so that you can quickly reapply a set of actions to a different range You can also star the most frequent features to have access to your favorites at any time   When you import data from different sources or share the same spreadsheet with colleagues it becomes critical to bring it in order in the shortest time possible Even such simple tasks as deleting all notes from your sheet can waste a lot of time Power Tools helps you do this in a click Here is a full list of tasks it performs ➊ Smart toolbar offers a set of oneclick actions Advanced find and replace in all selected sheets Insert cells and shift data down or right Delete cells and shift data up or left AutoSum all numbers in columns or rows Sum by fill and text color Flip values in adjacent cells rows or columns with or without their format Change case Freeze or unfreeze top rows and left columns   Main tool sets group solutions by type ➋ Remove unwanted data Delete leading and trailing spaces Reduce spaces between words to one Remove html entities nonprinting characters and delimiters Get rid of any character or string in the range Delete characters by position or those that follow or precede certain text Remove empty or unused rows and columns ➌ Clear data by type Erase any combination of data types from the selected range formatting numbers dates booleans notes text or hyperlinks  ➍ Work with text Capitalize each cell or word change case to uppercase or lowercase Add your text at the beginning or at the end of the selected cells before or after certain text or at any position you like Replace accented characters with nonaccented turn codes to symbols and back ➎ Convert data format Convert textformatted numbers and dates to numeric and date format Change number sign Export range to JSON or XML ➏ Try out the formula tools Switch formula reference type from relative to absolute or vice versa Get values instead of the formulas Automatically add functions to all selected columns Apply new calculations to all formulas at once ➐ Split tool set Separate values by any character or string Split text by position Extract name parts into separate columns ➑ Data tool set Identify duplicate records in any combination of columns on your sheet Compare two columns or sheets to find duplicates Join values in rows columns or the entire range and keep cells unmerged Merge sheets by a key column Shuffle values in rows columns or the entire range Generate random numbers dates booleans custom lists or strings Combine duplicate rows add subtotals and bring related values together

Get Power Tools add on for Google Sheets 1 month subscription now:

[sociallocker]Try Power Tools add on for Google Sheets 1 month subscription free version Power Tools add on for Google Sheets 1 month subscription full version Visit Power Tools add on for Google Sheets 1 month subscription product page [/sociallocker]
17Jun/19
ablebits-com-merge-values-add-on-for-google-sheets-lifetime-subscription.png

Download Merge Values add on for Google Sheets Lifetime subscription

Combine columns rows or ranges of data and preserve original values This addon will become your best assistant for merging values in adjacent cells Three simple settings let you decide if you want to combine multiple columns or rows pick the delimiter for the records and choose a place for the results Join values horizontally vertically or bring all records from the selected range into one cell Add results to the existing values or as a new column or row Merge cells without losing your data you can avoid the standard problem of “Keeping data only in the top leftmost cell” and retain all your records while removing borders between them Skip blanks wrap text and choose other additional options that tailor the results to your needs Besides there is a special option that creates a backup copy of your sheet in case you want to keep it the way it was You can set up the process in under a minute and concatenate data in seconds If you have any questions about the addon please post them in our community

Get Merge Values add on for Google Sheets Lifetime subscription now:

[sociallocker]Try Merge Values add on for Google Sheets Lifetime subscription free version Merge Values add on for Google Sheets Lifetime subscription full version Visit Merge Values add on for Google Sheets Lifetime subscription product page [/sociallocker]
17Jun/19
ablebits-com-merge-values-add-on-for-google-sheets-12-month-subscription.png

Free Merge Values add on for Google Sheets 12 month subscription

Combine columns rows or ranges of data and preserve original values This addon will become your best assistant for merging values in adjacent cells Three simple settings let you decide if you want to combine multiple columns or rows pick the delimiter for the records and choose a place for the results Join values horizontally vertically or bring all records from the selected range into one cell Add results to the existing values or as a new column or row Merge cells without losing your data you can avoid the standard problem of “Keeping data only in the top leftmost cell” and retain all your records while removing borders between them Skip blanks wrap text and choose other additional options that tailor the results to your needs Besides there is a special option that creates a backup copy of your sheet in case you want to keep it the way it was You can set up the process in under a minute and concatenate data in seconds If you have any questions about the addon please post them in our community

Get Merge Values add on for Google Sheets 12 month subscription now:

[sociallocker]Try Merge Values add on for Google Sheets 12 month subscription free version Merge Values add on for Google Sheets 12 month subscription full version Visit Merge Values add on for Google Sheets 12 month subscription product page [/sociallocker]
17Jun/19
ablebits-com-merge-sheets-add-on-for-google-sheets-lifetime-subscription.png

Full Merge Sheets add on for Google Sheets Lifetime subscription

Scan two sheets for the same values based on key columns and update your main table with the missing information Five simple steps of the Merge Sheets wizard will guide you through the process of joining data from two tables If you have at least one common identifier column in both sheets eg product ID the addon will insert all the missing information for the same records in your main table Select the table you want to update and the one to pull information from Define common columns the addon can use to find the same records Choose the columns to update or add to your main sheet The merge assistant will do the rest It will quickly compare key columns and find the necessary updates no vlookup formulas needed You can highlight changes with color work only with the empty cells and have all new records added to the end of the table When the merge is complete youll see the summary of all changes that the addon has made You can use this tool whenever you need to compare two sheets and bring the latest changes to your table

Get Merge Sheets add on for Google Sheets Lifetime subscription now:

[sociallocker]Try Merge Sheets add on for Google Sheets Lifetime subscription free version Merge Sheets add on for Google Sheets Lifetime subscription full version Visit Merge Sheets add on for Google Sheets Lifetime subscription product page [/sociallocker]
17Jun/19
ablebits-com-merge-sheets-add-on-for-google-sheets-12-month-subscription.png

Download Merge Sheets add on for Google Sheets 12 month subscription

Scan two sheets for the same values based on key columns and update your main table with the missing information Five simple steps of the Merge Sheets wizard will guide you through the process of joining data from two tables If you have at least one common identifier column in both sheets eg product ID the addon will insert all the missing information for the same records in your main table Select the table you want to update and the one to pull information from Define common columns the addon can use to find the same records Choose the columns to update or add to your main sheet The merge assistant will do the rest It will quickly compare key columns and find the necessary updates no vlookup formulas needed You can highlight changes with color work only with the empty cells and have all new records added to the end of the table When the merge is complete youll see the summary of all changes that the addon has made You can use this tool whenever you need to compare two sheets and bring the latest changes to your table

Get Merge Sheets add on for Google Sheets 12 month subscription now:

[sociallocker]Try Merge Sheets add on for Google Sheets 12 month subscription free version Merge Sheets add on for Google Sheets 12 month subscription full version Visit Merge Sheets add on for Google Sheets 12 month subscription product page [/sociallocker]