parse/format data in excel?

CFA General
#1

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?

#2

if “$4.52 Dividend” is in cell A1 then one thing you can use is the =LEFT(A1,5)

#3

=left(A1,len(A1)-8) where A1 is the cell location of “$4.52 dividend”

#4

Big Nodge method works too, but if your dollar amount is smaller or larger than 5 characters it fails.

#5

Or even just use the search and replace function and get rid of it entirely.

#6

also can use text to columns, delimited by the space

#7

or use the alt + d + e fixed width function, replace cells

#8

agree with JDV…just Find " dividend" and Replace with “”