Formatting cells with numbers and text

D

Dazed and Confused

I have a column of numbers with text; i.e., 23L252350, 06K100997, 50J304888,
etc. These numbers and text need to have a hyphen inserted after the first
two numbers/characters and the next four numbers/characters, i.e.,
23-L252-350, 06-K100-997, 50-J304-888. I tried using
Format-Cells-Number-Custom, but cannot seem to get it to work since the 3rd
character is usually (but not always) text.

Any assistance would be greatly appreciated. Thank you.
 
E

Eduardo

Hi,
try

=LEFT(B7,2)&"-"&MID(B7,3,4)&"-"&RIGHT(B7,3)

change the cell # to fit your needs
 

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

Formatting Text to Numbers for Dates 2
date and time in 2 cells to create subtraction in 3rd 2
Extract numbers from cell with Text and Numbers 3
CUSTOM TEXT FORMATTING??? 1
Numbers to sort as text 5
Help with cell formatting in macro. 7
Export Access to Excel text field with numbers 1
Find and move cells with text 8

Top