Hi All
I have a problem here, hope the experts can help.
1 Mickey Mouse #The | The Mickey Mouse
2 World History #The | The World History
3 National History | National History
4 The National Geography | The National Geography
5 Excel for Dummies #The | The Excel for Dummies
6 Expert | Expert
7 Excel 101 | Excel 101
The above shows a list of book titles in 1st column , if i want to remove "#The" from the back and send it to the front like 2nd column, what would be formula? (those without #The at the back should remain as it is)
Tq in advance :)
Regards/BKLim :confused:
Bookmarks