LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Replacing last 3 characters and adding them to front

Hi,

I had a question I was wondering if anyone could help me with.

I had an excel file with a bunch of numbers... Variable lengths. All
the numbers are in a single column. At the end of the numbers are
always 3 letters. Is there a way to delete those three letters off each
of these numbers and put them at the front of the number instead of at
the end?

For example...

111222457YAA should be converted to YAA111222457

Thanks for any help!!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding Text to a String Gene Haines Excel Discussion (Misc queries) 1 November 29th 06 05:34 AM
adding characters in excel column rita Excel Discussion (Misc queries) 3 February 16th 06 10:30 PM
Defined number of characters Carrie Excel Discussion (Misc queries) 3 February 2nd 06 05:44 PM
Exporting to CSV file with Chinese Characters in Spreadsheet Just Me Excel Discussion (Misc queries) 1 August 17th 05 11:37 AM
Adding characters Amy Johnson Excel Worksheet Functions 3 April 28th 05 07:41 PM


All times are GMT +1. The time now is 08:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"