Forum Discussion
Formatting in Excel
I am trying to format a cell so the output looks like C23-569-789 when the following is entered into the cell c23569789. I can't seem to get it to work because of the leading Alpha. Help.
Yes, you can't format the text such way
I am really surprised it is a NO.
You may use VBA to transform the text and return result into the same cell
do you have a suggestion on VBA?
I got close with =UPPER(LEFT(E1,3)&"-"&MID(E1,4,3)&"-"&RIGHT(E1,3)) but it is a function and requires two columns ... I only want one.
