Hi Lisa,

Assuming your APN# is in cell A1 the following will change it to 10
digits, as requested.

="0"&A1&"00"

Simply concatenate a zero to the beginning of the text string and two
zeros to the end.

HTH....Jay.


Lisa W. wrote:
I'm working on a spreadsheet with APN#'s. I need to change it from seven
38-21-200 characters to ten, something like this 038-21-20000. Any
suggestions on a wildcard to add a zero before and zeros after? Thanks.