tetx to columns not working

**:) Sixthsense :)** · 10-24-2012, 08:37 AM

Lot of methods are available I hope you should have exported it from any software or from some other source. Before pasting the data into excel just select the column or range and change the formatting as text. Use paste special and paste the data in excel as values and after that we can apply formula and extract each data by considering the comma as a separator.

**qwertyjjj** · 10-24-2012, 09:57 AM

Originally Posted by :) Sixthsense :)

Lot of methods are available I hope you should have exported it from any software or from some other source. Before pasting the data into excel just select the column or range and change the formatting as text. Use paste special and paste the data in excel as values and after that we can apply formula and extract each data by considering the comma as a separator.

No, I can't get that to work either.
Whether I add commas or paste as values into text fields it is still changing 330,335 to 330355 instead of 330 | 355

**:) Sixthsense :)** · 10-24-2012, 10:37 AM

Originally Posted by qwertyjjj

No, I can't get that to work either.
Whether I add commas or paste as values into text fields it is still changing 330,335 to 330355 instead of 330 | 355

I don't want you to spend more time in converting the numbers to text. Follow the below method

Copy the data and open New Microsoft Word and press Alt+E+S+U and paste the data

Press Ctrl+Shift+8

Now press Ctrl+H to get the find and replace dialog box and

in Find What type comma (,)
in Replace With type ^t

Click Replace All. Now copy and paste the converted data to excel.

In word again press Ctrl+Shift+8 to remove the paragraph marks.

^t will apply Tab. Tabbed Data will get placed in individual excel cell.

Using ^p will in Replace With will move the data to next row.

Hope that helps!

**qwertyjjj** · 10-24-2012, 11:18 AM

Copy the data and open New Microsoft Word and press Alt+E+S+U and paste the data

Press Ctrl+Shift+8

Now press Ctrl+H to get the find and replace dialog box and

in Find What type comma (,)
in Replace With type ^t

Click Replace All. Now copy and paste the converted data to excel.

stuck here, I pasted into excel and get 335 345 | 456 457 458 | 376 |
but then you say to go back to word?
In word again press Ctrl+Shift+8 to remove the paragraph marks.

^t will apply Tab. Tabbed Data will get placed in individual excel cell.

Using ^p will in Replace With will move the data to next row.

Also, I cannot replace ^t in excel, it doesn;t put them in new cells.