Synchronise excel formula in acces

[bjelinski]

Hello,

I have some problem with synchronizing excel formula to work at access database.
Following formula erases the last star with any characters after the star. Example: This ID CODE - 63047450201*RO*Kolis*RBBG*LIM would become THIS 63047450201*RO*Kolis*RBBG

=LEFT(C2,FIND("^^^",SUBSTITUTE(C2,"*","^^^",LEN(C2)-LEN(SUBSTITUTE(C2,"*",""))))-1)

My question is how can I acchive the same effect by using acces formulas? and if that is possible

thanks in advance

[royUK]

This is almost a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.