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 after about 1980 really do underestimate the benefits they have by having grown up with personal computers. They simply just think about them differently.
I'm sure you can do that 'natively' in Excel, but not my field of expertise; IIRC I actually spent longer faffing about in the Excel docs looking for a way to do this (and failing) than writing the awk regexes.
It did make me wonder how often some variant of this happens every day. "Data entry" is still a job, after all...
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 after about 1980 really do underestimate the benefits they have by having grown up with personal computers. They simply just think about them differently.