the "value" is giving the error......in your sample only the 1 is true number..all are text
![]()
=TRIM(MID(SUBSTITUTE($A1,";",REPT(" ",LEN($A1))),LEN($A1)*(COLUMN()-2)+COLUMN()-1,LEN($A1)))
the "value" is giving the error......in your sample only the 1 is true number..all are text
![]()
=TRIM(MID(SUBSTITUTE($A1,";",REPT(" ",LEN($A1))),LEN($A1)*(COLUMN()-2)+COLUMN()-1,LEN($A1)))
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks