Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-13-2013, 04:44 AM
OTPM OTPM is offline Code Request - Text to Columns Windows 7 32bit Code Request - Text to Columns Office 2010 32bit
Expert
Code Request - Text to Columns
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default 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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code Request - Text to Columns Comparing 2 columns of Text Berk21 Excel 9 02-03-2012 12:19 PM
Code Request - Text to Columns Pasted text comes in columns yotas312 Word 2 11-12-2011 07:58 AM
Code Request - Text to Columns The text in the two columns are not in the same level!!!! why? Jamal NUMAN Word 22 10-18-2011 09:00 AM
Code Request - Text to Columns text in columns not even KENDO Word 1 01-22-2011 01:06 AM
Code Request - Text to Columns how to center text in multiple columns galiwock Excel 1 05-12-2010 09:02 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:00 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft