Jump to content
Brewer Fanatic

Excel Formula: Delete everything before symbol


chowyo123

I'm in need of a formula for excel which will delete everything before an equal sign and put it into Column B, such as:

 

Column: A

john doe=123456abcd

 

Column: B

123456abcd

 

I did a google search and found the formula =RIGHT(A1,FIND("=",A1)) but instead of the output I want, it gives:

 

Column: A

john doe=123456abcd

 

Column: B

23456abcd

 

It always seems to cut off the first part of Column B.

Link to comment
Share on other sites

Recommended Posts

Archived

This topic is now archived and is closed to further replies.

The Twins Daily Caretaker Fund
The Brewer Fanatic Caretaker Fund

You all care about this site. The next step is caring for it. We’re asking you to caretake this site so it can remain the premiere Brewers community on the internet. Included with caretaking is ad-free browsing of Brewer Fanatic.

×
×
  • Create New...