adding zero th alpha numeric value

M

marziano

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
 
B

Bernie Deitrick

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

HTH,
Bernie
MS Excel MVP
 
Top