Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Text > PHONETIC

 

PHONETIC(reference)

 
 Returns the phonetic characters from a text string.

 referenceThe cell reference containing the text.

 REMARKS
 
  • If "reference" refers to a range of cells then the top left cell is used.
     
  • If "reference" refers to a range of non adjacent cells, then #N/A is returned.
     
  • This function is used in connection to phonetics and using different types of fonts and languages.
     
  • This function will probably not appear in the (Insert > Function) dialog box.

     EXAMPLES
     
     A
    1=PHONETIC("some text") = #NAME?
     

     Functions - P | Index - P | Text Manipulation | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top