Forum Discussion
Formatting issue
Hello, I am currently trying to format a spreadsheet where i require data in one column E.G 01_011_0107_1_1_T, 04_104_0125_1_1_T etc, where each line is a separate code but in another column I am re...
MoniqueMTarampaAssist For anyone who may have similar issues I have fixed it with =SUBSTITUTE(LEFT(O2,11),"_","") which has changed it from 01_011_0107_1_1_T to 010110107 - Still haven't been able to work out how to get a 2 in front of the second number but if anyone has any ideas on that I would be happy to try them 🙂