#1
|
|||
|
|||
Code Request - Text to Columns
Hi Forum Colleagues
I am looking for a piece of code that will allow me to paste copied text into a worksheet using the Text to Columns functionality before I place it into a column. The delimiter will be a comma. I need this because there will be some cells that will have more than 14 numbers separated by commas that I dont want Excel to treat as a number. They need to stay as text. An example of one row of data is: 365,366,428,416,417,418,419,420,421,422,424,425,42 6,427 Your help would be appreciated. Many thanks in anticipation. Tony |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Comparing 2 columns of Text | Berk21 | Excel | 9 | 02-03-2012 12:19 PM |
Pasted text comes in columns | yotas312 | Word | 2 | 11-12-2011 07:58 AM |
The text in the two columns are not in the same level!!!! why? | Jamal NUMAN | Word | 22 | 10-18-2011 09:00 AM |
text in columns not even | KENDO | Word | 1 | 01-22-2011 01:06 AM |
how to center text in multiple columns | galiwock | Excel | 1 | 05-12-2010 09:02 AM |