You may need to split the data because you may want to sort the data using a certain part of the address or to be able to filter on a particular component.
The delimiter indicates exactly where to split the text. This character separates each chunk of data within the text string.Ī big advantage of using a delimiter character is that it does not rely on fixed widths within the text. A delimiter character is usually a comma, tab, space, or semi-colon. You can split the data by using a common delimiter character.
When data is imported into Excel it can be in many formats depending on the source application that has provided it.įor example, it could contain names and addresses of customers or employees, but this all ends up as a continuous text string in one column of the worksheet, instead of being separated out into individual columns e.g.
0 kommentar(er)
