See sample. Thank you
need to have it in columns "need this" as result.
See sample. Thank you
need to have it in columns "need this" as result.
Please try
=--REPLACE(MID(A5,5,7),3,,LEFT(A5,3))
and
=--RIGHT(A5,5)
or
=MOD(REPLACE(MID(A5:A7,5,20),3,,LEFT(A5:A7,3)),{99999,1})
Thank you for your quick response.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks