Home |
Search |
Today's Posts |
#1
|
|||
|
|||
format text in excel
How do i format a text cell in Excel, for example: 1122AA to 11-22-AA
|
#2
|
|||
|
|||
Assuming that the text 1122AA is in cell A1 -
=LEFT(A1,2)&"-"&MID(A1,3,2)&"-"&RIGHT(A1,2) Regards. Bill Ridgeway Computer Solutions "JFlorindo" wrote in message ... How do i format a text cell in Excel, for example: 1122AA to 11-22-AA |
#3
|
|||
|
|||
if the length is fixed, and your text is in cell A1, then use:
=LEFT(A1,2)&"-"&MID(A1,3,2)&"-"&RIGHT(A1,2) Mangesh "JFlorindo" wrote in message ... How do i format a text cell in Excel, for example: 1122AA to 11-22-AA |
#4
|
|||
|
|||
Hi, J. If you want this to occur automatically, and supposing you type these
values into column A, then you can right-click the worksheet tab and hit View Code. Then paste this code into the code window that appears at right: Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Not Application.Intersect(Target, Range("A:A")) Is Nothing Then Target(1).Value = Left(Target(1), 2) & "-" & Mid(Target(1), 3, 2) & "-" & Right(Target(1), 2) End If Application.EnableEvents = True End Sub Code stolen from Chip Pearson's site and adapted for your purpose. http://www.cpearson.com/excel/case.htm ******************* ~Anne Troy www.OfficeArticles.com "JFlorindo" wrote in message ... How do i format a text cell in Excel, for example: 1122AA to 11-22-AA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
Copying excel format from cell to cell | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel |