hi!
i have a series of cells with text that looks like this
10,11.13;
5,155.07;
144,.89;
what formula (or formula combinations) can i use to get the info between the "," and the ";" into another cell?
thanks so much for your help!
=)
so for the above 3 cells i would want the
11.13
155.07
.89
i have a series of cells with text that looks like this
10,11.13;
5,155.07;
144,.89;
what formula (or formula combinations) can i use to get the info between the "," and the ";" into another cell?
thanks so much for your help!
=)
so for the above 3 cells i would want the
11.13
155.07
.89