Extract specific text from a text string

		Microsoft Office Forums > Microsoft Excel > Excel
Extract specific text from a text string

FAQ

Thread Tools

Display Modes

09-23-2022, 06:03 PM

Logit

Windows 10 Extract specific text from a text string

Office 2007

Expert

Join Date: Jan 2017

Posts: 587

Code:

      Formula in D4 :    =MID(C4,43,5)       Formula in D5 :    =MID(C5,43,5)       
  
      Formula in E4 :    =RIGHT(C4,29)       Formula in E5 :    =RIGHT(C5,29)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extract Text from a text string	Haha88	Excel	3	05-19-2022 08:27 AM
Extract Bold text from string	one4youman	Word VBA	8	04-18-2019 12:31 AM
Formula to Extract text from a text string	Haha88	Excel	2	11-14-2017 01:32 AM
Extract text from a text string	Haha88	Excel	8	02-13-2017 05:06 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 10:39 PM.