Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How to edit column B in spreadsheet so that the 1st 14 characters in the
string is cut/pasted to column Y, and the last 14 characters in the string is cut/pasted to column Z? Need to apply such an edit to all cells in column B. Spreadsheet is A1:Pxxxx (approx 3000 rows). All cells in column B contain a character string that represents 'model number - description label - part number'. String varies in length due to description label differences, however model number and part number are always 14 characters each. Cell format is general. MS Office Excel 2003, SP1 MS Windows XP Professional 5.1, SP 2, build 2600 Thanks for your help, R |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Wrap text in column headers to fit text in column | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
another text to column problem | Excel Worksheet Functions | |||
Counting every unique text string in a column | Excel Worksheet Functions |