Microsoft Office Tutorials and References
In Depth Information
The text is the text string or word you want to extract from.
The start_num is the number of the character within the text string or
word you want to extract from.
The num_char is the number of characters to extract from the
start_num point to the right.
Start with character 1
Count 4 characters
Use the MID function
as a standalone
function or in combination
with other functions
such as FIND .
Formula extracts first name
The PHONETIC function extracts the phonetic or furigana characters from a text string in
When using the different language packs in Excel 2000, you’ll have to use this function to
adjust or change characters from the text string.
This is text or cell reference that contains the text that you want to
extract the phonetic or furigana characters from.