Apr 26 2019 08:29 AM
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
Apr 26 2019 08:42 AM
SolutionApr 26 2019 10:00 AM
Thank you, Sergei - that's perfect.
Apr 26 2019 02:02 PM
@carlos2250 , you are welcome
Apr 26 2019 08:42 AM
Solution
Hi Carly,
That could be
=REPLACE(REPLACE(MID(A1,8,6),3,,"/"),6,,"-")