| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Removing text characters
Hi,
I have a column of text reference codes, which I need to adapt into a more appropriate format (values). NOW DESIRED 709A 709 495R 495 1B 1 1075T 1075 111115D 111115 Effectively, I need to remove the text character at the end of the code, which will then allow me to convert the former text code into a value. If there is a function I can use this would help me greatly. Kind regards, Scott |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Save As... text with special characters | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| how do I highlite text within a cell (specific characters) | Excel Discussion (Misc queries) | |||
| 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 | |||
Threaded Mode
