Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split Cells using a Function
I have a series of cells in a column that looks like {2X, 1X, 3X...}etc. I
need to split the number from the letter, and yet have it flexible, so if I change a 2X to a 1X, the split updates automatically, which is not what Text to Columns does. I am using Excel 2003. If there is a formula or something that does this, I would be greatly appreciative. Thanks -Morpheus |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split Cells using a Function
Hi
It depends on what other entries you have in your series. For the ones shown you could just use =LEFT(A2,1) but that might not fit for all of the possibilities. Andy. "Morpheus2067" wrote in message ... I have a series of cells in a column that looks like {2X, 1X, 3X...}etc. I need to split the number from the letter, and yet have it flexible, so if I change a 2X to a 1X, the split updates automatically, which is not what Text to Columns does. I am using Excel 2003. If there is a formula or something that does this, I would be greatly appreciative. Thanks -Morpheus |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Split cells below header column: | Excel Worksheet Functions | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Use TREND function with nonadjacent cells | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
write a function to determine if cells have names | Excel Worksheet Functions |