View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dplunkett dplunkett is offline
external usenet poster
 
Posts: 6
Default 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