Windows 10: Want to insert Specific Text or number or date for more than one file.

Let say, I want to insert text "PD_" for each file file may be word, excel, pdf etc


Before adding text "PD_"






After adding text "PD_"




:)

 

In CALC convert text date to number date

The reason for the conversion was to put a long column of text dates, like 03/10/1998 in chronological order.

After much searching, I found this gem on my hard drive. It works for OpenOffice Calc so it may work for Excel.

If you want to apply a numerical format to a column of numbers in text format (for example, text "000123" becomes number "123"), do the following:

1. Select the column in which the digits are found in text format. Set the cell format in that column as "Number".
   
2. Choose Edit - Find & Replace
   
3. In the Search for box, enter ^[0-9]
   
4. In the Replace with box, enter &
   
5. Check Regular expressions
   
6. Check Current selection only
   
7. Click Replace All

 

List of tooltip texts

• Do not translate the IDS_ strings, only what's inside the "s
• \n is a newline character that acts like "return" is pressed. so text\n\ntext2 adds a blank line between "text" and "text2"
• %s is replaced by some inserted text, you may move the %s to other positions within the text, but if multiple %s are present they will be inserted in the same order in all languages

 

N81 - Insert number into SMS?

My phone is N81 2GB. How can I insert number from contact list into text message please?

Message Edited by on 23-Jan-2008 09:55 AM