delete data

  • Thread starter Thread starter donald8188
  • Start date Start date
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.
 
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)
 
Hi
if your data is stored in A1 enter the following formula in your target
cell
=LEFT(A1,FIND(" ",A1)-1)
 
Back
Top