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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to add the same alpha-numeric value to all the content of a co 3
Adding alpha-numeric value in from all alphabetic content in a col 3
enter numeric value starting with zero 3
only extract numeric value from alpha numeric cell 5
Replace each heading with a unique numeric value 3
Alpha & Numeric Counts in Excel 3
Min Value 4
converting Postal codes to numeric value 4

Top