What u see is in Column A, Please give me a formula to extract the Buyer names in Column B without all the other junk.
Buyer name:
John Dieero
hfg
jgf
jdg
jjhgk
hfg
j
dkh
jgs
kh
js
shgf
kj
hjdgh
kgh
j
gdk
gdhk
dghj
dghk
Buyer name:
Marc Turner
fhs
gsj
fs
gj
gj
hg
kgh
ghk
hgk
d
jgsfj
fgj
shgk
gd
js
gfj
k
hgsj
gfj
Buyer name:
James Dea
khgd
k
gl
hjl
jkd
ghk
lj
hdk
lj
h
kdlh
kgh
ld
skh
hdh
skh
hks
khhk
s
dkhg
Buyer name:
Paul Reirt
kdhg
khd
lkhfj
lkhfj
jl
h
lf
hjl
dhk
hgdk
lh
j
dkgh
lhj
kd
lj
d
5:03 AM PST
kdhg
Buyer name:
Joanna Eirop
hdjg
kdg
hkdg
hkhg
dk
ghk
ghk
dgh
khdg
kgd
kg
dk
hl
fhj
ff
hjl
12/21/2017
lj
jfl
Buyer name:
Paul D Johnson
jfl
l
l
hfjl
hl
h
lj
fhl
fhl
jfh
lfh
jlf
hjlf
hh
l
hfjl
lhf
l
lfjh
Buyer name:
Peter green
Bookmarks