| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
FORMATING COLUMNS..... HELP
"JTEFUN" wrote in message
... I need to format columns to allow only 7 characters and the rest of the data to go into column B -- JTEFUN Column A: Input Column B: =LEFT(A1,7) will abstract the first 7 characters Column C: =MID(A1,8,99) will abstract characters 8 through 99 Regards. Bill Ridgeway Computer Solutions |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formating: Compare two columns with Inserted lines | Excel Worksheet Functions | |||
| formating numbers to text in columns | Excel Discussion (Misc queries) | |||
| Cell formating and Rolling columns | Excel Discussion (Misc queries) | |||
| conditional formating of group of columns and rows | Excel Worksheet Functions | |||
| Formating columns | Excel Discussion (Misc queries) | |||
Hybrid Mode
