delimited

I have an email folder with multiple emails that contain similar content. I would like a quick way to move all the data into Excel. Separating each contact by columns is the goal: sent, to, date, email body etc. I know I can save each email into notepad and copy into Excel and transpose but...

I am trying to use ConvertXLS.EXE from the webpage listed below. I have 4 Excel files with 3 tabs of data each. I am trying to convert to a pipe delimited text file. In the output folder I designate, I end up with 4 files. Not only that, each file pulls data from only one tab. How do I...

Hello Excel Experts, I have been trying this a number of ways and I can not find a way (if it's possible) to make it work. I have a | delimited text- i.e. 1|2|3|4|5|6 and I would like to take this text and paste it into a cell, A1 Upon pasting it into a cell (if macro is used, that is fine)...

Hi everyone. I have a giant list people, and am having a problem with cleaning the data and making it uniform. The issue is that there is supposed to be a column that has name suffixes (Jr, Sr, iii ect), but many of the names have the suffix after the last name. I am trying to move them over...

The below code is working for me but I need to make a few adjustments which I can't figure out. I have one column where a cell contains 4 delimited values and a dollar value. eg 22-4-3-7 $217560.00 My aim is to cut the delimited values into each of 4 different columns I have inserted leaving...

Hi All Ms Access Guru I've been trying to export only 4 coulmns i.e. c1,c2...c4, the last column c4 keep some null values , but I would like to to replace last column value if null = "" Sam value as TextQualifier During Export Wizard, (It does show me some output rows sample and in there it...

Hi, i have to delimite the following data, written in a single cell. Barclays PLC Citi Deutsche Bank AG Goldman Sachs & Co HSBC Holdings PLC Merrill Lynch Morgan Stanley & Co RBS UBS excel showing small rectangle between two lines. how to delimite such text....

Hi, I am getting pretty frustrated with the following: On PC_A (and all other pc's I tried) I open a csv file (tab delimited) with a .xls extention via file / open. The import wizard starts. Fields with a line feed in it causes Excel to start a new row mixing up the columns.:mad: Opening the...