THE GIVEAWAY BLOG!! Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.
Log in

I forgot my password

Search
 
 

Display results as :
 


Rechercher Advanced Search

Poll
Keywords

Latest topics
» How Can I Convert EML to PST Outlook Format
Using Find & Replace To Made You Work Be Easy!! EmptySat Mar 02, 2019 5:50 pm by toddgross0007

» EML to PST
Using Find & Replace To Made You Work Be Easy!! EmptySat Mar 02, 2019 5:49 pm by toddgross0007

» Restore IncrediMail Email
Using Find & Replace To Made You Work Be Easy!! EmptyThu Feb 28, 2019 5:36 pm by toddgross0007

» How to Recover IncrediMail Folders That Disappeared
Using Find & Replace To Made You Work Be Easy!! EmptyThu Feb 28, 2019 5:34 pm by toddgross0007

» EDB to PST Converter software
Using Find & Replace To Made You Work Be Easy!! EmptyTue Feb 28, 2017 6:39 pm by toddgross0007

» Convert OST to PST utility
Using Find & Replace To Made You Work Be Easy!! EmptyTue Feb 28, 2017 6:29 pm by toddgross0007

» MBOX to PST Converter
Using Find & Replace To Made You Work Be Easy!! EmptyWed Jan 25, 2017 3:11 pm by emersonhurst

» SQL Database Recovery
Using Find & Replace To Made You Work Be Easy!! EmptyWed Jan 25, 2017 3:09 pm by emersonhurst

»  MBOX to PST Convert software
Using Find & Replace To Made You Work Be Easy!! EmptyFri Jan 06, 2017 3:48 pm by geetjit13


Using Find & Replace To Made You Work Be Easy!!

Go down

Using Find & Replace To Made You Work Be Easy!! Empty Using Find & Replace To Made You Work Be Easy!!

Post  THE GIVEAWAY BLOG!! Tue Jan 12, 2016 8:29 pm

While we wanted to replace a word with it on many coloum , it will taken time to replace it by one by one .
But with this function just one click excel will help you replace all the same word in 1 time.

Find the word you want to replace , in here we want to change "Tree" to "Red"

[img]Using Find & Replace To Made You Work Be Easy!! 1110[/img]

Click the "Find" Button On "Ribbon" and choose the find function .

[img][img:766f]http://i68.[img][url=https://servimg.com/view/19391676/28]Using Find & Replace To Made You Work Be Easy!! 1511[/img]servimg.com/u/f68/19/39/16/76/1216.png[/img:766f][/url][/img]

In here Type the word you want to "find" for replace after click on the "Replace" Tab and type the word you wanna replace on the "replace with" box.

[img]Using Find & Replace To Made You Work Be Easy!! 1317[/img]

Now just click the Replace All / Replace button to replace by 1 or all , after the excel will help you replace it , and will pop-out a message say all data has been replace .

[img]Using Find & Replace To Made You Work Be Easy!! 1413[/img]

Now You work has been done , check all the data with "Tree" has been replace to "red" .




THE GIVEAWAY BLOG!!
THE GIVEAWAY BLOG!!
Admin

Posts : 161
Join date : 2012-06-11
Age : 35
Location : Malaysia

http://thousandgiveaway.blogspot.com

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum