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
tmajor99Asked:
Who is Participating?
 
Saqib Husain, SyedEngineerCommented:
=left(A2,len(A2)-1)
0
 
HuaMin ChenSystem AnalystCommented:
Try
=MID("QB_Index_*C",1,LEN("QB_Index_*C")-1)

Open in new window

0
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.