| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text - Remove text Item No.99 (First 2 Chars) and move to end
I have series of nos in a spreadsheet listing.
Format is as folows:- NNNNNNNN (8 Chars) I need a way of searching where code is 99 - first 2 chars where exists and be able to remove these from front of text string add to end of text string Example Extract from Listing Cell Reference V7 99030599 - Remove 99 and add to end, Result: 03059999 01020304 - No Change 99040405 - Remove 99 and add to end, Result: 04040599 Please advise as unsure which text functions needed to complete the adjustment? Many Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Restrict no of chars in text box | Excel Discussion (Misc queries) | |||
| import text file with tab chars in it | 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 | |||
| remove blanks from a string of chars within a cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
