text to column data issue

Hi there, I'm new to the forum and to excel, to some extent. I'm looking for some advice so I can complete a quantitative form for the company I work for. In short, what needs to happen is: I enter a few key products into a certain cell that actually subtract the calculated measurement instead...

I need a macro to help with text to columns for a document of inconsistent strings. Ex strings 123456 *toName 4 100.00 234567 fromName 2 12.000 2 Q12:toName:fromName:1 165.0 183.7 26.0 185.5 112.5 234567 *toName2 2 17.000 345678...

I was recently handed in a text file I am trying to create a spreadsheet or CSV from the contact information. I have noticed that I have "missing spaces" and cannot find a method of shifting the cells to properly store the details. I have included the following as an example of the text...

I was hoping someone would be able to assist me with a question I have regarding a text-to-columns type scenario. I have copied names, number, address and titles from a website but when i past it into excel it all goes into column A. Normally, if the data was uniform and consistent, you could...

Here's the situation. we are moving to a new CRM (or to a single REAL CRM if you want to be honest) and we need each phone number in a new column with out the jargon (random notes) behind it. The phone number are in one column now, separated by an alt return. The phone number look like the...

So I have this problem when importing a csv file, one cell has information that needs to be split into columns or repeated with the same tablet id. I have tried several combinations but everything takes time and it is not clean and it doesnt solve the problem, any ideas data is below and the two...

Hi, I have data in text file in '|' (pipe) separated format. When I copy and paste that in excel sheet, i then use text to column formatting function. However, after this first instance, every time I copy data and paste on the another sheet of the same excel or even if I open new file and paste...