Hello. I need to use the CONCAT function. I have several numbers in A1-A15, and in B1-B15 I need it to show the same number but with i: in front, and ; in back.
Example:
A1 number: 109137
B1 Number should become: i:10285;
I have tried using this formula in B1, without success: =CONCATENATE("i:",A1,";")
Solved by C. S. in 27 mins