Overview

The Excel Add Data, Text & Characters To All Cells Software provides a powerful method for inserting text into a range of cells within MS Excel. Microsoft Excel provides limited built-in capabilities when it comes to adding text to a range of cells. This software allows the addition of text to the following locations:

· Beginning Of Selected Cells

· End Of Selected Cells

· Before Specified Pre-existing Text In Selected Cells

· After Specified Pre-existing Text In Selected Cells

· Before a Numeric Position In Selected Cells

· After a Numeric Position In Selected Cells

· Before a Numeric Position In Selected Cells (Counting Backwards)

· After a Numeric Position In Selected Cells (Counting Backwards)

· Before All Upper Case Letters In Selected Cells

· After All Upper Case Letters In Selected Cells

· Before All Lower Case Letters In Selected Cells

· After All Lower Case Letters In Selected Cells

In addition a range of cells may be padded with spaces to a specified uniform width.

Main Screen

The Add Data, Text & Characters To All Cells Software can be started by double clicking the icon on the user’s desktop or choosing it from the Start Menu. Since the software is a MS Excel Add-In doing so will result in MS Excel being started with the Add-In installed. The Add-In is labeled “Add Text” and may be accessed from the “Add-Ins” menu as shown below:

In addition to the Main Screen, if you are using the free version of the software an additional window is displayed. This window offer you links to “Buy Now”, “Enter License”, “Support” and “sobolsoft.com”.

The “Buy Now” link will use your default internet browser to display a page that will allow you to purchase the software and receive a License. The license may be entered into the dialog that is displayed when you choose the “Enter License” link. The “Support” link uses your default browser to display a list of frequently asked questions at https://sobolsoft.com/question/ and the “sobolsoft.com” link will bring you directly to the Sobolsoft website at www.sobolsoft.com.

Once a license has been entered in the “Enter License” window this window is no longer available but all of the information is still available at the sources listed above.

Accessing The “Add Text” Functionality

To access the functionality of the “Add Text” Add-In, simply click on the “Add Text” menu item in the Add-Ins menu. This will display the following menu

The menu is divided into sections. The first section has entries to allow the user to enter text at the beginning or end of a selected range of cells. The next section has selections for adding text before or after existing text in a selected range of cells. The third section allows entry of new text in a specified numeric position in a selected range of cells. The fourth allows the user to insert new text before or after upper or lower case letters in a selected range of cells. The fifth allows the user to pad the right of each cell in a range with spaces, out to a specified width. The last section is for application specific information.

Specifying Text To Add To Cells

Selecting any of the menu items that allow the user to specify what text should be added to each cell in the range of selected cells will result in the following dialog being displayed:

The user may choose to add specific text. To do this the user would select the radio button labeled “Text” and enter the text to add in the edit box such as:

In this case the string foo will be added in the specified location. If the user simply wants to embed a return character in each cell of the selected range of cells then the radio button labeled “Enter” should be selected. If the user simply wants to embed a tab character in each cell of the selected range of cells then the radio button labeled “Tab” should be selected.

This applies to all of the menu items outlined in red below:

Specifying An Insertion Character(s)

Some of the menu items allow text to be added before or after specific text in a cell. If this is the case the user will be prompted with the following dialog, before being prompted for the text to add:

Specify the character(s) to find in the cell, before or after which the new text will be added. If the character string entered does not exist in a particular cell in the range, no new text is added. This dialog is displayed for the menu items below outlined in red:

Specifying An Insertion Position

Some of the menu items allow text to be added to a numeric position in each cell of a selected range of cells. When one of these menu items is selected, the user will be asked for the numeric position in the cell where the text should be added. This is done before the user is prompted for the text to add as described above using the following dialog:

The numeric position refers to the position of the character in the cell where the text will be inserted before or after. The only characters entered here must be digits.

This dialog is displayed for each of the menu items outlined in red below:

Adding Text To Beginning Of Selected Cells

Selecting the menu item:

And specifying:

With the following cells selected:

Will result in the following:

Adding Text To End Of Selected Cells

Selecting the menu item:

And specifying:

With the following cells selected:

Will result in the following:

Adding Text Before This Character (Or Characters) In Each Selected Cell

Selecting the menu item:

And specifying:

and

With the following cells selected:

Will result in the following:

Adding Text After This Character (Or Characters) In Each Selected Cell

Selecting the menu item:

And specifying:

and

With the following cells selected:

Will result in the following:

Adding Text Before This Numeric Position In Each Selected Cell

Selecting the menu item:

And specifying:

and

With the following cells selected:

Will result in the following:

Adding Text After This Numeric Position In Each Selected Cell

Selecting the menu item:

And specifying:

and

With the following cells selected:

Will result in the following:

Adding Text Before This Numeric Position (Counting Over From The Right Side) In Each Selected Cell

Selecting the menu item:

And specifying:

and

With the following cells selected:

Will result in the following:

Adding Text After This Numeric Position (Counting Over From The Right Side) In Each Selected Cell

Selecting the menu item:

And specifying:

and

With the following cells selected:

Will result in the following:

Adding Text After All Upper Case Letters In Selected Cells

Selecting the menu item:

And specifying:

With the following cells selected:

Will result in the following:

Adding Text Before All Upper Case Letters In Selected Cells

Selecting the menu item:

And specifying:

With the following cells selected:

Will result in the following:

Adding Text After All Lower Case Letters In Selected Cells

Selecting the menu item:

And specifying:

With the following cells selected:

Will result in the following:

Adding Text Before All Lower Case Letters In Selected Cells

Selecting the menu item:

And specifying:

With the following cells selected:

Will result in the following:

Padding Selected Cells with spaces

It is sometimes desirable to have fixed width cells. That is, every cell has exactly the same amount of characters, with the right hand side padded with spaces. You can achieve this quickly and easily with this software by choosing:

This will display the following dialog prompting the user for the desired fixed width of the cells

If the value entered here is not greater than the number of characters in the longest cell, nothing is done. Otherwise all of the cells are padded on the right with space, out to the width specified.

Application Specific Menu Items

Clicking on the “Add Text” Add-In Entry will bring up the menu including the application specific menu items displayed below:

The “Product Website” item will display the website below in your default browser:

https://sobolsoft.com/excelabs/

The “Watch Help/Demo Video” will show the following avi formatted video:

How To Load Software Into Excel 2003 and 2007.avi

Email Author will display the following website in your default browser:

https://sobolsoft.com/question/

And open a new email to support@sobolsoft.com in your default email client.

The “Enter Personal License” item will display the following dialog:

This will allow you to enter the license number purchased from Sobolsoft. The “Remove this Addin From Excel” will remove the “Add Text” Add-In from the Excel Add-In menu.