Log in
Search
Keywords
Most Viewed Topics
Latest topics
Using Find & Replace To Made You Work Be Easy!!
Page 1 of 1
Using Find & Replace To Made You Work Be Easy!!
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][/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][/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][/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][/img]
Now You work has been done , check all the data with "Tree" has been replace to "red" .
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][/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][/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][/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][/img]
Now You work has been done , check all the data with "Tree" has been replace to "red" .
Similar topics
» Using Find & Replace To Made You Work Be Easy!!
» Easy To Fill The Numbering With Fill Function!!
» Easy To Fill The Month With Fill Function!!
» Easy To Fill The Month With Fill Function!!
» Easy To Fill The Same Data In Same Coloum!!
» Easy To Fill The Numbering With Fill Function!!
» Easy To Fill The Month With Fill Function!!
» Easy To Fill The Month With Fill Function!!
» Easy To Fill The Same Data In Same Coloum!!
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|
Sat Mar 02, 2019 5:50 pm by toddgross0007
» EML to PST
Sat Mar 02, 2019 5:49 pm by toddgross0007
» Restore IncrediMail Email
Thu Feb 28, 2019 5:36 pm by toddgross0007
» How to Recover IncrediMail Folders That Disappeared
Thu Feb 28, 2019 5:34 pm by toddgross0007
» EDB to PST Converter software
Tue Feb 28, 2017 6:39 pm by toddgross0007
» Convert OST to PST utility
Tue Feb 28, 2017 6:29 pm by toddgross0007
» MBOX to PST Converter
Wed Jan 25, 2017 3:11 pm by emersonhurst
» SQL Database Recovery
Wed Jan 25, 2017 3:09 pm by emersonhurst
» MBOX to PST Convert software
Fri Jan 06, 2017 3:48 pm by geetjit13