deliminator

Hi, Firstly.. Thanks to anyone that reads this and gives me help. I'm a total beginner when it comes to this and I'm not even too sure on how to ask this question properly. :biggrin: OK.... I'm trying to create spreadsheets using data downloaded from an electrical testing device, Specifically a...

Hello forum, I have a workbook, that I use to import data into our ERP. I have 3 columns(E,F,G) that I will input a number into. I want to concatenate the 3 columns in Column H. While inputting nothing if the column is empty. EFGH1Depot 1Depot 2Depot...

I would like to build a list within a single cell from a sting stored another cell. The string has a semi colon delimiter ';' to separate the string SMTP, smtp, X400, FAX. Unfortunately the x400 portion of the string also has semi colons which need to be kept. Its delimiter is a second semi...

Hi All, This is my first time on this and this forum seems very helpful from the other post i've seen. I am working on a large set of data. Each row contains a column with cells such as below *** DD-MM-YYYY (ZZ) *** Random text sajfoadfoasdkdasn fddnvadnv dfkbaf *** DD-MM-YYYY (ZZ) *** Random...

I have a txt file that needs to be converted from txt to csv with excel. Process needs to be automated and I am not sure how to do this at all. Any input would be a big help. The deliminator is a | Thanks Keith

Hi All, I have been searching everywhere, but nothing came up. I have long list of data (asett IDs). All of it is in the following format. AA-BB-CC-CC001 The number of dash occurences can vary based on the level the asett is located in. I need to extract the parrent of the asett to...