Extract specific text from a text string

Logit · #1 09-23-2022, 06:03 PM

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)

Haha88 · #2 09-24-2022, 05:01 AM

Quote:

Originally Posted by Logit

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)

Thank you for your help.

This formula will work for this particular line. However, there are many other lines that don't have the same length of characters therefore these don't quite work.

Many thanks,

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