Format cell with text and numbers entered

In A1 Cell
XYZ0000000000

In B1 Cell
=SUBSTITUTE(TRIM(A1),RIGHT(TRIM(A1),10)," ")&TEXT(RIGHT(TRIM(A1),10),"000-000-0000")

welcome to the forum, keanve. do you mind typing in Column A & have the results in Column B? type this formula in B2:
=LEFT(A2,3)&TEXT(RIGHT(A2,10)," 000-000-0000")

to make it come out automatically as you type in Column A, convert the range to a Table. do that by selecting A1:B3 for eg & press CTRL + T. you can see Sheet2 of the file. type in A4 & B4 will be filled.

if you mind an extra column, you might need to do VBA.

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Double-click on the worksheet you want to apply too. Mine is in Sheet1
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

type into column A & it'll convert into the format you want. change this line of code to identify which column you want it applied to. Column A is 1, B is 2, & so on:

Please Login or Register  to view this content.