Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-19-2012, 12:55 AM
Flabbergaster Flabbergaster is offline Search and replace tabulators of different length...? Windows XP Search and replace tabulators of different length...? Office 2010 (Version 14.0)
Novice
Search and replace tabulators of different length...?
 
Join Date: Oct 2010
Posts: 8
Flabbergaster is on a distinguished road
Default Search and replace tabulators of different length...?

Hi


I have this source text (*.rtf) containing information in (sort of) tab-seperated columns. I want to copy it into a excel worksheet to do further analyzing.
My problem is, that the tabulator signs 'moving' the text into columns are of different length in the .rtf/.doc file, but exporting it excel treats them the same:

In the rtf file the signs look like this:

------------->

------------------------------------------>

Reading them as separators excel treats them alike.

I guess what I'm looking for is an easy way to (maybe w/search&replace) make the 'long' tabs into several tabs:

------------->
------------->------------->------------->

Real examples attached

It must be a 'automatic' solution, since we're talking about a rtf file of 1000+ pages..
Attached Files
File Type: docx example.docx (34.2 KB, 14 views)
File Type: xlsx example.xlsx (11.8 KB, 10 views)
Reply With Quote
 

Tags
columns, search/replace, tabulator



Similar Threads
Thread Thread Starter Forum Replies Last Post
Advanced search and replace for bullet points TishyMouse Word 5 02-17-2012 06:32 AM
Any wildcards search and replace in Powerpoint 2010? tinfanide PowerPoint 0 09-10-2011 02:17 AM
Search and replace tabulators of different length...? WORD: Rtf and search-replace (regexp/fonts) seteshpl Word 1 09-06-2011 01:35 AM
Search Replace Copy dblack7211 Word 0 05-05-2010 01:19 PM
Search and Replace - Clear Search box JostClan Word 1 05-04-2010 08:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:31 AM.


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