How to remove a suffix in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

type I have the following example data in cells and need to separate the
suffix.
Adelphi Blue7
The suffix may be alpha or numerical but in all cases there is no space
between the main text and the suffix.
 
and I also need to use the suffix i.e. put Adelphi Blue in one cell/column
and the suffix in another
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

return a value in one cell based on multiple formulas 2
Sorting rows with alphanumeric starter cells 8
How to open an .xlsx file with Excell 2
How to ignore the last char in some cells 4
Changing Values in Fields 5
Data in columns 1
Sorting Numbers w/Aplha Suffix 5
MID, LEFT, RIGHT help 5

Back
Top