Trying to delete "=" sign at end of text column if there is an "=" in the field

K

Kent

=IF(RIGHT(A2,1)="=",MID(A2,1,LEN(A2)-1))

Excel Support Technician
www.canhelpyou.com
-----------------------------------------------------------
-----------
Every member of the CanHelpYou team holds at least a
Microsoft Level 1 Excel certification. In addition, we
have experts in PowerPoint, Word and other products such
as IIS, SQL Server 2000, network connectivity.
-----Original Message-----
Anyone have any ideas for this? I'm trying to get to the
Click to expand...
point where I can at least return a '1' if there is an "="
at the end of the column and a '2' if not. I'm thinking it
might be a IF, RIGHT or something, but I need help. I just
want to strip the "=" sign off the end of a field if there
is an "=" at the end.
 

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

How to center adjust text above and image in a two column document. 1
Delete all data after a symbol in a field 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Finding the right style field in VBA 0
How can the font and size of (all) citation numbers be altered? 1
Using Styles In An Outline 0
Unexplained failure of wdFindStop at end of search 0
Counting instances of Specific column entry combinations 1

Top