hi,
You may use the clipboard from the edit menu.select the cell containing
ABCDEF. Select the required portion ' AB' on the function tab ,click edit
menu, click copy .By this AB is copied to the clipboard.Similarly the portios
C and DEF can also be selected and copied to the clipboard (maximum 12
values/texts) .Then select the cell in which you want AB to be shown.Please
click the required item from the clipboard.Similarly, do this for other
values also.
K.S.Warrier

"Dock Buddy" wrote:

I am trying to create a fomula that will give me the following results.
1st fomula cell K18 - If h18 is greater than 70 but less than 100 x it by .19
2nd fomula cell L18 - If h18 is greater than 100 but less than 300 x it by
.14
3rd fomular cell M 18 - If h18 is greater than 300 then x it by .12
I have tried H18<70100*.19. It enters the results regardless of the figure
in cell 18. Please help!!!!!!!!!! Thanks