Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-18-2014, 11:19 PM
Allen Allen is offline Need Help to Find a Number and replace Windows 7 64bit Need Help to Find a Number and replace Office XP
Novice
Need Help to Find a Number and replace
 
Join Date: Nov 2014
Posts: 3
Allen is on a distinguished road
Default Need Help to Find a Number and replace

Hello Everyone

I have a set of document in Which every sentence is numbered


Eg 1 today is monday.2 I need to go to work.3 My office is situated at the northeast of NY.4 I am stuck in a traffic

I want to break the sentence when it starts with a number. I Need to split the sentences as below.
Eg
1today is monday.
2I need to go to work.
3My office is situated at the northeast of NY
4I am stuck in a traffic

I have more than 900 pages of document. Help is much appreciated.

Thanks in advance.

Allen
Reply With Quote
  #2  
Old 11-18-2014, 11:37 PM
macropod's Avatar
macropod macropod is offline Need Help to Find a Number and replace Windows 7 64bit Need Help to Find a Number and replace Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You can do this with a wildcard Find/Replace, where:
Find = ([!0-9 ][.\?\!])([0-9])
Replace = \1^l\2
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-19-2014, 02:06 AM
Allen Allen is offline Need Help to Find a Number and replace Windows 7 64bit Need Help to Find a Number and replace Office XP
Novice
Need Help to Find a Number and replace
 
Join Date: Nov 2014
Posts: 3
Allen is on a distinguished road
Default

Thank you for your reply Paul

It's not working.

Prompt message : Search item was not found.
Reply With Quote
  #4  
Old 11-19-2014, 04:26 AM
macropod's Avatar
macropod macropod is offline Need Help to Find a Number and replace Windows 7 64bit Need Help to Find a Number and replace Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Did you check the 'use wildcards' Option? If so, your document's content evidently differs from your post. In that case, please attach a document to a post with some representative data (delete anything sensitive). You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 11-20-2014, 10:16 PM
Allen Allen is offline Need Help to Find a Number and replace Windows 7 64bit Need Help to Find a Number and replace Office XP
Novice
Need Help to Find a Number and replace
 
Join Date: Nov 2014
Posts: 3
Allen is on a distinguished road
Default

Yes. I have checked the wildcards option. I have attached the document. Kindly check
Attached Files
File Type: docx teapot.docx (10.4 KB, 8 views)
Reply With Quote
  #6  
Old 11-20-2014, 10:33 PM
macropod's Avatar
macropod macropod is offline Need Help to Find a Number and replace Windows 7 64bit Need Help to Find a Number and replace Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Your document's content is nothing like what you described in your post!

Your post describes sentences terminate by periods, with a number immediately following and a space between that and the following text.

Your document has non-breaking spaces instead of periods and no spaces between the numbers and the following text.

How you could expect a working solution when your problem description is so far off the mark is a mystery.


For the document you have attached, you can do this with a wildcard Find/Replace, where:
Find = ^s([0-9]@[A-Z])
Replace = .^l\1
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need Help to Find a Number and replace replace number with formatted number antoniob Word 5 06-17-2014 02:32 PM
Need Help to Find a Number and replace Find what box in Find and replace limits the length of a search term Hoxton118 Word VBA 7 06-10-2014 05:05 AM
Find/Find and Replace Loop Tango Mike Word 3 04-20-2014 02:47 PM
Need Help to Find a Number and replace Bad view when using Find and Find & Replace - Word places found string on top line paulkaye Word 4 12-06-2011 11:05 PM
Need Help to Find a Number and replace Help with find and replace or query and replace shabbaranks Excel 4 03-19-2011 08:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:47 AM.


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