use only the first 3 letters of cell data

  • Thread starter Thread starter N E Body
  • Start date Start date
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
 
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
 
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 :-)
------------------------------­------------------------------­----------------
 
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 :-)
------------------------------­------------------------------­----------------
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change order of 5 letter word based on another cell containing 5 numbers 5
If formula evaluating 2 cells contents 3
Count occurences of a letter in a cell 2
Formula Result is "V6", need Excel to use cell "V6", not the resul 3
Excel Use COUNTIF across a range of cells with formulas 0
Substitute letters by others in a word 4
Excel Sum numbers in cells that also contain text 34
Excel Add ^ to a row of cells containing letters 3

Back
Top