Can you please help me to create a Formula, I get an error every time I try to add the one that i had
I attach the file,
if I just the formula I don't need to concatenate
But I get an error #VALUE!
@Deleted , the #VALUE error is returned since you multiply number 1 on the text returned by MID(). I guess that was misprint, you don't need that.
In addition to the formula @Twifoo suggested you may use Data->Text to Columns or Flash Fill, depends on needs.
thanks for the support, I will try @Sergei Baklan