| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Input cell on Data Table will not work | Excel Discussion (Misc queries) | |||
| format cell from data input to output form | Excel Worksheet Functions | |||
| Import Data into same cell | Excel Discussion (Misc queries) | |||
| Repeat Cell Data | Excel Worksheet Functions | |||
| sending data from one cell to another (not using copy & paste) | Excel Worksheet Functions | |||
Hybrid Mode
