Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Each cell in column A contains multiple entries separated by a comma and a
space (e.g., P7899, P7899.7, P9250, P9261). Ideally, I would like to use a built-in function (versus a custom function if possible) that extracts the contents of each cell in column A and puts the component pieces into separate cells in column B. Using the previous example, one cell in column A would become four cells in column B. Thanks for the help. Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple Formulas in same cell | Excel Worksheet Functions | |||
Multiple Formlas in same cell | Excel Discussion (Misc queries) | |||
Counting Multiple Values In A Cell | Excel Worksheet Functions | |||
Identify repeated cell entries in multiple sheet workbook as you . | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |