use only the first 3 letters of cell data

N

N E Body

Hi everyone

I need to split data. A cell contains CHH05 and I need a formula that will
give a result of CHH.

Could someone suggest a solution?

TIA

Kenny
Win NT and 2000 with Office 97
 
R

Ron Rosenfeld

Hi everyone

I need to split data. A cell contains CHH05 and I need a formula that will
give a result of CHH.

Could someone suggest a solution?

TIA

Kenny
Win NT and 2000 with Office 97
Click to expand...

=LEFT(cell_ref,3)


--ron
 
K

Ken Wright

Just for info, Data / Text To Columns / Fixed Width would also have done
this for you.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
K

Ken Wright

Just for info, Data / Text To Columns / Fixed Width would also have done
this for you.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
Top