Add a carriage return in data

[red2002yzfr1]

I need to add a carriage return in a data field at "*break*" text. Also, would be nice if it deletes the search text.

 

[WayPay]

Something like:

[data field] = Replace([data field], "*break*", vbCrLf)

 

[red2002yzfr1]

Thanks, You Rock!