Excel tips

May 10

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)

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word