EXCEL - How to truncate the last char.

Can you please tell me how In EXCEL, I can truncate the last char.

Before                      After
  A                                 B
QB_Index_*C          QB_Index_*
QB_Index_J2           QB_Index_J
Who is Participating?
Saqib Husain, SyedEngineerCommented:
HuaMin ChenSystem AnalystCommented:

Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.