delete data

D

donald8188

New to excel functions

I'm trying to delete text from a field

I have a field with joe,blow h

I would like to delete everything after the first space.
 
B

Bob Phillips

Hit F2, and edit it in the formula bar

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
F

Frank Kabel

Hi
if your data is stored in A1 enter the following formula in your target
cell
=LEFT(A1,FIND(" ",A1)-1)
 
Top