Text to column funtion.

[dmrosy]

I’m using Windows 7 and Excel 2007. I have a problem with text to columns. I import daily trades from my brokerage. It looks like this: 03/30/2015 14:32:52. The spaces between the date and the hour are not being recognized by any of the delimiters. Fixed width works fine . I would like to turn the process into a macro using delimiters. Does anyone have an suggestions?

[daffodil11]

It may be an invisible character. Assuming A1 has the full original string: "03/30/2015 14:32:52", type =CODE(MID(A1,11,1)).

This will give you the value of the worksheet CHAR() or VB ASC() you need to delimit upon.

[dmrosy]

Thanks Daffodil. The code was 160. Unfortunately, I don't know what to do with it now that I have it. I tried putting "160" in the "other" check box but it only accepts 1 character. Hope you can get me the rest of the way. David

[daffodil11]

Sure, in a cell put =CHAR(160).

Then copy that cell and paste values in another cell.

Enter that cell with F2, and hit Ctrl+A to select the hidden character, and Ctrl+C.

Now go to the delimiter in Text to Columns, and paste it in there.

[ChemistB]

With the cursor in the Other box, enter ALT + 0160 (you should see the cusor move a space to the right)
That worked for me

[dmrosy]

Just to be clear; there is no "+" before the "0160" correct?

[dmrosy]

Paste it where? in the "other" box. Did it. Does not work. How do I send you a spreadsheet? I'll show you what Im trying to do. Thanks David

[ChemistB]

To attach a workbook
Go Advanced>Manage Attachments