Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi all,
I have a column of cells containing text strings, and I want to omit the first word from each cell, which are of varying character lengths. I can do it the long winded way using a combination of the text functions (i.e. left, mid etc..), but is there a quicker way to omit the first word? The character lengths of the first word vary from 4 to about 9 characters. I have over 10000 cells to check. Any help would be much appreciated. Regards, Bhupinder Rayat |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I set text to top of cell next to wrap text in Excel? | New Users to Excel | |||
Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
Split Long Text Cell into Two Shorter Cells Without Splitting Word | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) |