Excel tips
Jesse Lau
1 min read
Just working for google merchant data.
I have to insert some text to the whole cell. Record tips here.
I also have to find some text including "|"
I have to insert some text to the whole cell. Record tips here.
1. B1 ="SOME TEXT BEFORE"&A1
2.Copy B1 to whole b1-b100
3. select paste back to a1 with just value.I also have to find some text including "|"
1. B1 = MID(A1&"|",1,SEARCH("|",A1&"|")-1)
Comments