HOW TO: Report a portion of a string of text (i.e. characters 4-6) from another cell

[carlos2250]

Hello,

I am trying to determine how to write a formula to pull specific characters from a text cell and populate a new text cell.  For example:

Column A contains the full text string (22 characters in total) and I would like column B to report characters 8 and 9, add a "/", and then characters 10 and 11, add a "-", and then characters 12 and 13)

Ex: Column A = SK WI 102012200315W200 and I want Column B to = 02/01-22 

Thanks in Advance!

Carly

[#2 · Accepted solution]

@carlos2250 

Hi Carly,

That could be 

=REPLACE(REPLACE(MID(A1,8,6),3,,"/"),6,,"-")

[#3]

Thank you, Sergei - that's perfect.

[#4]

@carlos2250 , you are welcome