Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-17-2015, 06:37 PM
maukford maukford is offline Editing text before running text to columns Windows 8 Editing text before running text to columns Office 2013
Novice
Editing text before running text to columns
 
Join Date: Jan 2015
Posts: 2
maukford is on a distinguished road
Default Editing text before running text to columns

I have been given a mish-mash of data from a word doc that needs to be put into columns. See sample:
B, 01/20/15, 7:30am-10:30am, Conf Room ABC
CH 02/06/15, 7:30am-10:30a, 40ppl Pinard Foyer
B 02/18/15, 11:30am-2:30pm. 30ppl, Conf Room ABC
CH 2/23/15, 7:30am-10:30am, 40ppl SECC D
FH 3/07/15 7:30am-10:30am, 40ppl SECC B
B, 3/31/15, 7:30am-10:30am, 30ppl, Knowledge Room

Is there a way to edit/format this text without doing it line by line before running the Text to Columns?

Thank so much,
Maukford
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Editing text before running text to columns Editing text in text boxes--please help--driving me crazy! Samantha Jean Word 7 02-09-2017 02:22 AM
editing text and remove spaces romanticbiro Word VBA 5 07-04-2014 07:42 PM
Editing text before running text to columns High CPU usage while editing text jat255 PowerPoint 3 01-22-2014 05:15 PM
Editing text before running text to columns One click check box with text editing sephiroth2906 Word 3 01-11-2012 10:21 AM
Editing text before running text to columns Editing Text amberroad Word 6 03-20-2011 04:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:26 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