હિમાંશુ પરભુભાઇ મિસ્ત્રી | Himanshu Mistry

મે 23, 2008

One trick in MS OFFICE for Find and Replace

Filed under: how to,learning — Himanshubhai Mistry @ 9:48 પી એમ(pm)

 

One trick in MS OFFICE for Find and Replace

MS Office 2003 allows find and replacing dependent vowel symbols like hrswa i deergha ee hrswa u deergha oo etc.
I had discovered this trick at the time when I was doing all data corrections after converting the lexicon-data to Unicode.
For example if you want to convert a document typed in SARTH to UNZA…
You can replace all hrswa i to deergha ee as well as all deergha oo to hrswa u

We have to type the dependant i vowel symbol in a notepad and then copy and paste to find and replace window like shown below

find-and-replace-i

Then only the buttons (replace/replace all and find next) will be activated.
If you click replace all, it will replace all hrswa I with deergha ee…..
Similarly for hrswa u and deergha oo
See the picture below
find-and-replace-u.jpg

 all the best

મે 7, 2008

searching for Linebreaks inside a cell MS Excel

Filed under: Uncategorized — Himanshubhai Mistry @ 4:07 પી એમ(pm)

Searching for Line breaks inside a cell MS Excel

Sometimes you will find a line break (new paragraph/line) inside a cell in Excel.
And if you need to remove all unnecessary line breaks in a sheet.

To find and replace in Excel, you can use “Alt+0010” inside the Find & Replace box.
You will not see anything in Excel’s F&R box, but the code is there.
You can replace all line breaks with either a space or nothing.

I found this tip/trick on http://www.necco.ca/dv/ppt_excel.htm

 I will upload some screenshots also after some time.

 

Blog at WordPress.com.