Combine data from more than 1 cells in Excel
Use concatenate function to combine data from more than 1 cells. This is very useful if you are working with tans of data to be combined.
Continue ReadingUse concatenate function to combine data from more than 1 cells. This is very useful if you are working with tans of data to be combined.
Continue ReadingYou can count number of characters in Excel by using the available functions in Excel, follow the below easy steps on how to count number of characters: 1) Let say you have a file which contains addresses as per sample below: 2) You wanted to know number of characters plus the empty spaces, at any […]
Continue ReadingIf you have a bunch of data in EXCEL that you would like to convert the format from TEXT to NUMBER, the following steps is best to change the format as quickly as possible in EXCEL: 1) Open your Excel file which you want to convert the data. Data that you want to convert to […]
Continue Reading