Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding Text to a String | Excel Discussion (Misc queries) | |||
adding characters in excel column | Excel Discussion (Misc queries) | |||
Defined number of characters | Excel Discussion (Misc queries) | |||
Exporting to CSV file with Chinese Characters in Spreadsheet | Excel Discussion (Misc queries) | |||
Adding characters | Excel Worksheet Functions |