| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text function
I have an extract from a long list below. I would like to strip out the
second number from each text. i.e example from the first two rows are 1000 and 3104 respectively. Any help would be greatly appreciated. 010114 Long K 1000 Basic Pay 042140 Balard S 3104 FLS AD Hrs 040557 Sanjay Conroy A 3001 Fee 042316 Christie Eron C 1006 Basic Arrs 020674 De Thang C 1104 Basic-FLS 040203 De La Conjo MF 1000 Basic Pay 020025 Van Wanjo E 1010 Lon All'ce 040471 Van Kot FWM 1102 Basic-FLC 040471 Van Kot FWM 1112 L.A. - FLC |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using a conditional suffix in text function format syntax=text(value,format_text) | Excel Worksheet Functions | |||
| Can Text Function change output text color? | Excel Discussion (Misc queries) | |||
| Advanced text function (combining text) | Excel Worksheet Functions | |||
| Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
| Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
Threaded Mode
