Some Microsoft Office Hacks Found Along The Way

Some Microsoft Office Hacks Found Along The Way

1600 900 fradipta25

Here`s just list of Some Microsoft Foocice Hacks Found Along The Way. The way of ngopreking. So i have to google it no more

 

Word

  1. Use “^p” to find or replace “New Line”

 

 

Excel

  1. Replacing new line in excel can be done in 2 options, in case one method is not functioning. First, Using “CTRL+J” in find. or using this formula: =SUBSTITUTE(SUBSTITUTE(B2,CHAR(13),””),CHAR(10),””)    . “B2″ is an example of of the cell we want to replace, and put the char we want to use as a replacement inside the quote of:  CHAR(13),””) . So the end result in case we want to change the new line into space is:  =SUBSTITUTE(SUBSTITUTE(B2,CHAR(13),” “),CHAR(10),””)

 

 

 

 

Image: cnet.com