Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-06-2014, 11:25 PM
thetraininglady thetraininglady is offline Text in string Windows 7 64bit Text in string Office 2010 32bit
Competent Performer
 
Join Date: Sep 2014
Location: Sydney, Australia
Posts: 214
thetraininglady is on a distinguished road
Default


FYI for future reference,if you do not wish to affect other data in your workbook, copy & paste the text strings into a new blank workbook. Select the entire column containing this text string, choose Data > Text to Columns. Choose the File type as Delimiter then click Next, Change the type of delimiter to "space" (easiest option), then you can either just click Finish and your text string should be shown separated into column I, you can then cut & paste column I into another workbook for use.

This is 2 minute process at most to complete.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Text in string Way to search for a string in text file, pull out everything until another string? omahadivision Excel Programming 12 11-23-2013 12:10 PM
Text in string Extracting a phone number from a string that contains text and numbers. hommi16 Excel 2 06-05-2013 09:19 PM
Text in string Find and replace a string of text errtu Word 1 01-31-2013 02:09 PM
Text in string Convert numbers to a specific text string francis Excel 1 10-06-2011 01:43 PM
Extract numbers from a text string aleale97 Excel 4 02-10-2011 10:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:36 PM.


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