Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-04-2019, 07:36 PM
jack71 jack71 is offline Remove lines not starting with a numeric Windows 10 Remove lines not starting with a numeric Office 2016
Novice
Remove lines not starting with a numeric
 
Join Date: Aug 2019
Posts: 2
jack71 is on a distinguished road
Default Remove lines not starting with a numeric

Hi,



how can I remove lines within each cell (multiple lines with line breaks) that are not starting with a numeric character?

223213 - this line needs to stay
chair - this line needs to be removed
9 - this line needs to stay
needs to be removed

Thanks for your help,
Jack
Reply With Quote
  #2  
Old 08-04-2019, 08:17 PM
Alansidman's Avatar
Alansidman Alansidman is offline Remove lines not starting with a numeric Windows 10 Remove lines not starting with a numeric Office 2019
עַם יִשְׂרָאֵל חַי
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 79
Alansidman will become famous soon enoughAlansidman will become famous soon enough
Default

crossposted at: Remove specific lines within cell

and

Remove lines not starting with numeric character
Reply With Quote
  #3  
Old 08-05-2019, 05:00 AM
jack71 jack71 is offline Remove lines not starting with a numeric Windows 10 Remove lines not starting with a numeric Office 2016
Novice
Remove lines not starting with a numeric
 
Join Date: Aug 2019
Posts: 2
jack71 is on a distinguished road
Default

Sorry for that. Now read the rules.
Both solutions worked perfectly on this link:
Remove lines not starting with numeric character
Thanks and best,
Jack
Reply With Quote
  #4  
Old 08-08-2019, 03:49 AM
Lugh's Avatar
Lugh Lugh is offline Remove lines not starting with a numeric Windows 10 Remove lines not starting with a numeric Office 2016
Competent Performer
 
Join Date: May 2019
Location: USA
Posts: 137
Lugh is on a distinguished road
Default

Thanks for reporting back, that's helpful
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove lines in Text boundaries Peter Em Word 8 05-28-2018 06:15 PM
Remove lines not starting with a numeric Remove table lines gogreen Word 4 02-02-2018 03:14 PM
Remove lines not starting with a numeric remove blank lines in between jolinchew Excel 4 08-01-2013 06:09 AM
Asian typography in text boxes - how to avoid lines starting with periods markpete Word 0 11-17-2012 01:45 PM
Remove lines not starting with a numeric how to remove two lines? mryevrah Word 2 05-05-2011 01:41 AM

Other Forums: Access Forums

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