Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is this even possible?
I have a list of sizes contained in cells in Column C. Column C 4 x 32 x 1 16 x 32 x 1.25 14.375 x 23 x 1.25 6.5 x 52 x 1.25 4.5 x 23 x 1.25 2.5 x 23 x 1.25 What I need to do is look at each populated cell in Column C and remove the first number, the space following the first number, the "x", and the space following the "x" so I will end up with this: Column C 32 x 1 32 x 1.25 23 x 1.25 52 x 1.25 23 x 1.25 23 x 1.25 This one is WAY beyond me, any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trimming text from the end of cell contents. | Excel Worksheet Functions | |||
Trimming/Truncating Text Field in Excel | Excel Discussion (Misc queries) | |||
Trimming text | Excel Worksheet Functions | |||
Grid column display text trimming | Excel Discussion (Misc queries) | |||
trimming blank cells | Excel Worksheet Functions |