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,