jeudi 7 mai 2020

Concatenate specific values from a cell with specific values from another cell into a particular format

enter image description here

          A                       B                                       C
1       numbers                  signs                                **Result**
2    *001*                 *alpha*                       001-alpha
3    *001*111*221*104*     *alpha*kappa*epislon*ETA*     001-alpha, 111-kappa, 221-epislon, 104-ETA
4    *001*085*             *alpha*delta*                 001-alpha, 085-delta

I'm trying to concatenate the values in columns A and B into the following format under the result section. Anything helps, thanks.

Aucun commentaire:

Enregistrer un commentaire