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:31 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"

" />

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

[img][/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.

" />

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 .

" />

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

[img][/img]
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