Add Data - Tools

Add Text at beginning of each cell This program is again within the top 10. Suppose you have a large amount of data and you want to prefix this data with some other text, then use this function. For example you have employee Ticket Number list of 10,000. Suddenly you are asked to prefix all the ticket number with the Alphabet "A" for inputting into the mainframe. Just select the range of ticket number and select this function. It will ask you what to prefix and in a flash the alphabet "A" will be added in the beginning of each data.

Add Text at end of each cell This is same as the earlier Program but in this case the Text you decide will be added to the end of each data.

Add leading Zeros to Numbers (will become Text)   There are times when the  number of characters in a numeric column must be of same size. This is specially true for bank related data. E.g. 123.34 and 12355.56 must be of same size i.e.. 00123.34 and 12355.56. This program will help you do this, but mind you, the numbers will now become text.

Add Blank spaces at the end of data to make it of specific length

This program is very useful when the data in a column need to be of specific length and if necessary blank spaces need to be added at the end. This program will do just that but it will also convert numbers to text after giving you a warning. Please always save your file before trying anything new.