| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Need insert a dash in between last 4 digits in text string
I have a column (TractID) that has a 10 character text string, like the
following entry: 0190003164. First, I need to grab the last four digits (3164) of the entry, copy them to the next column (PropertyID), then insert a dash (-) between the 3rd to last (from the R) and the 2nd to last characters. The data in the column will always be the same format, if that helps. How do I do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert a JPEG into EXCEL 2002 | Excel Discussion (Misc queries) | |||
| insert picture | Excel Discussion (Misc queries) | |||
| Insert Line Macro | Excel Discussion (Misc queries) | |||
| How to insert a repeating dash in phone numbers without dashes in. | New Users to Excel | |||
| Challenging Charting | Charts and Charting in Excel | |||
Threaded Mode
