custom formatting??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Do you know if you can force a specific formatting for a column? What I want
to do is, I have a column with a MAC Address that looks like this:
005004a1b4a9 and I would really like to reformat it to something like this:
00-50-04-a1-b4-a9. Is there a way to do this automatically with the columns
already populated?

Thanks in advance!
 
Number formatting will work with numbers--not text.

But you could insert a helper column and make it look like you want:

=if(a1="","",mid(a1,1,2)&"-"&mid(a1,3,2)&"-"&mid(a1,5,2)&"-"&mid(a1,7,2)& ...

(I got tired! Just continue until you're out of letters <vbg>.)
 
Thanks Dave! Saved me alot of time!!

Dave Peterson said:
Number formatting will work with numbers--not text.

But you could insert a helper column and make it look like you want:

=if(a1="","",mid(a1,1,2)&"-"&mid(a1,3,2)&"-"&mid(a1,5,2)&"-"&mid(a1,7,2)& ...

(I got tired! Just continue until you're out of letters <vbg>.)
Click to expand...
 
You must log in or register to reply here.

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

separating date and time 5
Countifs with different restrictions 1
Data extract 10
Peculiar default cell format 1
trying to match text in 2 worksheets 1
vlookup or index for text on 2 worksheets 2
Extracting just the time portion 5
Custom Format or use function? 4

Back
Top