Excel tips

2014-05-10 55 words 1 min read

Just working for google merchant data.

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)

 

 

author

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.

We notice you're using an adblocker. If you like our webite please keep us running by whitelisting this site in your ad blocker. We’re serving quality, related ads only. Thank you!

I've whitelisted your website.

Not now

Post Your Comments Here:

Our website uses cookies to improve your user experience. If you continue browsing, we assume that you consent to our use of cookies. More information can be found in our privacy policy Got it