Hi.
How do I change letter group of numbers (eg: from "average(c12:c15;c20;c25;c30...)" to "average(f12:f15;f20;f25;f30...)") - I don't need to work too?
Hi.
How do I change letter group of numbers (eg: from "average(c12:c15;c20;c25;c30...)" to "average(f12:f15;f20;f25;f30...)") - I don't need to work too?
Just once? Use the Find / Replace menu.
When I say semicolon, u say comma!
use find &replace function
crtl + h
Click on * below if you find this helpful
Thanks,
A
copy the formule 3 cells to the right.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
[img=http://s15.postimg.org/7c0ohq34n/excel_find_replace.jpg]
I can't replace from "c*" to "f*".
Last edited by nunito; 08-07-2013 at 04:21 PM.
You only have to use "C" and "F", not "C*" and "F*"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks