Search results

It works perfectly for me. Because the replacement function cut off everything to the right of point X, A left before then works perfectly Left([column1],X-1) & Replace([column1],"m","n",X) Replace starts at position X, and cuts off everything before it, as per my original question, so having...

concatenating left with replace works, thanks!

I'm using the replace function to select a "," and put in an "&". I only want to replace once and I need it to to start after x characters, we will say 5 just for this example. Replace([string],",","&",5,1) That is the command I am using. The problem is that if I use that function, it...