| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Truncating a text string
In A1 I have the following:
A4 Black A4 Black+1 A4 1 colour A4 2 colour A4 4 colour A3 Black A3 Black+1 A3 1 colour A3 2 colour A3 4 colour I want to strip the leading two characters and the first space away leaving me with: Black Black+1 1 colour 2 colour 4 colour Black Black+1 1 colour 2 colour 4 colour I've been fiddling with this for a while but can't get it - I'd appreciate some help. Regards, Gavin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
| Finding Specific Text in a Text String | Excel Worksheet Functions | |||
| Formating a text string? | Excel Discussion (Misc queries) | |||
| Newbie: How to search a text string from right | Excel Worksheet Functions | |||
Threaded Mode
