Hi,
I want to separate the group numbers in row A, each of them contains 3~5 numbers, I want to separate the first number into row C and the second into row D, and then calculate their average in C24 & D24.
I've separate them by using "left" function, and convert them from text to number, but it can't calculate the average as every of them are following by some spaces, please help to solve the spaces, thanks.
Bookmarks