ExcelBanter - use only the first 3 letters of cell data

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - use only the first 3 letters of cell data (https://www.excelbanter.com/excel-worksheet-functions/41502-use-only-first-3-letters-cell-data.html)

N E Body

use only the first 3 letters of cell data

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

Ron Rosenfeld

On Sun, 21 Aug 2005 19:39:36 +0100, "N E Body"
wrote:

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

=LEFT(cell_ref,3)

--ron

N E Body

Many thanks Ron

That did the trick!

Regards
Kenny

"Ron Rosenfeld" wrote in message
...
On Sun, 21 Aug 2005 19:39:36 +0100, "N E Body"

wrote:

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

=LEFT(cell_ref,3)

--ron

Ron Rosenfeld

On Sun, 21 Aug 2005 19:55:26 +0100, "N E Body"
wrote:

Many thanks Ron

That did the trick!

Regards
Kenny

You're welcome. Glad to help.

--ron

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 :-)
------------------------------*------------------------------*----------------

"N E Body" wrote in message
...
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

Ken Wright

All times are GMT +1. The time now is 07:21 PM.