Convert a formula into text

  • Thread starter Thread starter Alexandra
  • Start date Start date
A

Alexandra

I downloaded a text file from a client data software. Now
when I opened the txt file in excel it converted one
column into formulas when it should have been txt. For
example in the txt file reads "-AD", now in excel reads "=-
AD". It's giving me a display "#NAME?". What I really need
is just to get rid of the "=" sign. I tried diferent ways.
I used txt functions like text, trim, left, right, etc. I
also tried copy and paste as value. Is there any other way
to do this process smoother and faster? what do you
suggest I need to do? This file as 2,000 plus rows. Right
now I changed the cells format to text but it doesn't
change it automatically. I have to edit and hit enter for
the data in cell to pick the txt format, create a new
column then use the left or right txt function. Please
advise,

Thanks, Alexandra
 
Select range, then Edit / Replace / 'replace what' is =, 'replace with'
just leave blank - Hit OK.
 
Select the column with the formulas. Select Edit from the menubar, then replace. Replace "=" with "-" or nothing

Hope that helps.
 
Back
Top