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

View previous topic View next topic Go down

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

Post  THE GIVEAWAY BLOG!! on 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][/img]

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

[img][img:766f]http://i68.[img][url=http://www.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" .




avatar
THE GIVEAWAY BLOG!!
Admin

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

View user profile http://thousandgiveaway.blogspot.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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