How to filter a document in Excel?

Question

excel

Hi all. Even it is difficult given, however.
you need to bring to a certain format, an excel document with data collected in third-party software. The algorithm is simple, but its implementation is difficult. the procedure is simple
1. Look at the text in cell B1
2. Everything after the comma is cut out and moved to C1
3. In C1, the comma and all spaces before/after are removed
The algorithm is simple. But excel, as it turned out, is a dark forest for me - if you need to do something more complicated than calculations in it.

Answer 1

I suggest you start like this. In C1, we write
Add the function SUBSTITUTE () ... Perhaps TRIM () will come in handy ... here you need to look at the format more specifically ...
You can ask questions))