adding zero th alpha numeric value
 

hello
i have an mp3 catalogue.column F indicates the location of every piece
and the velues in it are in the alpha numeric form of mp3 - xxx. i now
need to switch to thousands instead of hundreds. is there a formula
that can do this (convert mp3 - 234 to mp3 - 0234)?
thanks

adding zero th alpha numeric value
 

Select column F, and then use Edit / Replace. Replace dash/space with dash space zero.

HTH,
Bernie
MS Excel MVP


"marziano" wrote in message
oups.com...
hello
i have an mp3 catalogue.column F indicates the location of every piece
and the velues in it are in the alpha numeric form of mp3 - xxx. i now
need to switch to thousands instead of hundreds. is there a formula
that can do this (convert mp3 - 234 to mp3 - 0234)?
thanks