I have to insert some text to the whole cell. Record tips here.
2.Copy B1 to whole b1-b100
3. select paste back to a1 with just value.
I also have to find some text including "|"
Authored By Jesse Lau
A freelancer living in New Zealand, engaged in website development and program trading. Ever won 1st ranking twice in the Dukascopy Strategy Contest. This article is licensed under a Creative Commons Attribution 4.0 International License.