how to work with RegEx in Excel 2013

I need to replace substrings in cells and it is neccessary to work as well with special chars like \, #, |, ^, but it depend if they are on the beggining or end of line (Carredge return and line feed). So it saounds to me good candidate to use RegEx, but in my version of Excel 2013 regex are not supported. Can sombody give me advice which addin or VBA function to utilise?

Thanx in advance

Tomáš

Thanx for reguest, i will carefuly read the help, but for first try i did following (to replace = with CR and/or LF)

=SUBSTITUTE(D8;"=";"k"&CHAR(13)&CHAR(10))

And it did not work, But anyway i will chceck how it works and if it will be able to find simmilary to regex:
-find at beginning of string
-find at the end of string
-find firs number after upercase letters...

I will use it.

Toma