| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
