Data Deletion

Topic

New Reply

Hey folks!

I have a situation where I had to import a selection list of data (from HTML). It is all formatted as follows:

the second set of 0000 will be alpha and or numeric. I need to delete everything in the string after the quote, including the quote. All of the data after the quote is structured the same.

0000″>0000 – xyz

Any Ideas?

thanks,
Brad

Reply | Quote

Replies

This will return everything up to the ”
=LEFT(A1,FIND(“”””,A1)-1)

Reply | Quote

Ok, that works good. Now, how about the other direction?

I have another column where I need to see only the info after the “> I have already stripped the .

0000”>0000 – xyz

I played a little with the first method, but am not hitting the correct combination.

Thanks,
Brad

Reply | Quote

This will return everything after the first > =mid(A1,find(“>”,A1),99).

extra “(” removed – sorry Brad.

Reply | Quote

Kept getting an error with the formula. Discovered the extra (. Removed and works great

Thanks,
Brad

Reply | Quote