I downloaded dividend history of a stock into excel from yahoo and each cell says “$4.52 dividend”. How do I get rid of the word “dividend” so i can just use the numerical value?
if “$4.52 Dividend” is in cell A1 then one thing you can use is the =LEFT(A1,5)
=left(A1,len(A1)-8) where A1 is the cell location of “$4.52 dividend”
Big Nodge method works too, but if your dollar amount is smaller or larger than 5 characters it fails.
Or even just use the search and replace function and get rid of it entirely.
also can use text to columns, delimited by the space
or use the alt + d + e fixed width function, replace cells
agree with JDV…just Find " dividend" and Replace with “”