Ah, Army IT style. Back in my conscript days, the unit's secretary once had to take a list of soldiers from system A (LASTNAME/FIRSTNAME) and convert them to the format required by system B (FIRSTNAME,LASTNAME)... so she was doing this manually in Excel: click, highlight, ctrl-X, delete, cursor cursor, ",", ctrl-V, repeat. So I dumped the file to CSV, wrote a one-liner awk script that did the transformation, and impo…
You could text-to-columns it then concant it via B1 & "," & A1 then drag down. Alternatively, you could use =left(find()) and =right(find()) to function it. I touched on it in the mainteannce/ops space, but the admin space is also susceptable to this. I find that there's a very rapid change in fundamental understanding of capability between age groups. Of course there's exceptions in both parties but many people born…
It did make me wonder how often some variant of this happens every day. "Data entry" is still a job, after all...