I need to create a QR code out of a few pieces of user-entered information, we will call them a b and c. I am doing this using a google sheet document and embedding this formula into a cell:=if(isblank(A4), , image(https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=&A4&B4&C4))Which uses this API:https://developers.google.com/chart/infographics/docs/qr_codesI need to concatenate these pieces of information, but I also need to do some trickery on b. Specifically, b is a fixed string of 8 characters (ex. K1J05359). As it turns out, the 3rd character (always a letter), corresponds to a two-digit number that I need. Here is how these letters are mapped, and these are the only letters that will be used:00-B01-C02-D03-E04-F05-G06-H07-J08-K09-L10-M11-N12-P13-Q14-R15-S16-T17-UI need to extract the 3rd character (in this case, J), and change b so that it goes from K1J05359 to 07K105359. And that's where I am stuck. 
Transform a string according to a table of replacements
google spreadsheets;google apps