How to hide First 7 and last 8 characters from text value.

I am trying to accomplish two things.
in column A I have text value: MEN-FP-CUSTOMFLAG-XLG-NVY
I want it to show in column B: CUSTOMFLAG , removing first 7 and last 8 characters or hiding it.

second issue: in column B, when pasting values from column A, in this case MEN-FP-CUSTOMFLAG-XLG-NVY, I want in column A to paste value in C if its available, if not keep pasting value in B.

Thanks!

Possibly with a MID function formula in column B...

Formula:

Please Login or Register  to view this content.

Thank you so much! spent so much time looking for it. it works great. Could you please help with the second issue also. how can I make this formula to look at both column A and column B values. and always display A value unless B value has data in it. than display B value if there is date.

Originally Posted by dangelor

Possibly with a MID function formula in column B...

Formula:

Please Login or Register  to view this content.

Thank you so much! spent so much time looking for it. it works great. Could you please help with the second issue also. how can I make this formula to look at both column A and column B values. and always display A value unless B value has data in it. than display B value if there is date.

Try this:

= IF(B1<>"",B1,A1)

Originally Posted by Phuocam

Try this:

= IF(B1<>"",B1,A1)

thank you! how should I add previous formula to hide first and last characters within this if value?

Maybe like this?

= IF(B1<>"",MID(B1,8,LEN(B1)-15),MID(A1,8,LEN(A1)-15))