Excel tips

2014-05-10 55 words 1 min read

Website Programming

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)

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.

❮ Step-by-step Tutorial Show How to Build a Nice Wordpress Blog with Perfect 100 Score of Google Pagespeed Insights and A Rating of SSL Certificate within 2 Hours Missing required field "entry-title", "updated", hCard "author" solution ❯

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