Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How do I cut and paste the text or value in a cell without the formula?

I Have a simple spreadsheet that I use to document each field I spray.



Producer

Feild

Feild Operation

Date

Product

Product Cost

Rate

Rate Type

Cost/Ac

Acres

Total Product

Total Cost

GFL

27 North

Spraying

5/5/15

Start up

5.7

1/2

L/ac

2.85

315

157.50

897.75

GFL

27 North

Spraying

5/5/15

Heat

285

1/80

Jug/ac

3.56

315

3.94

1122.1875

GFL

27 North

Spraying

5/5/15

Pursuit

179

1/120

Jug/ac

1.49

315

2.63

469.875

GFL

27 North

Spraying

5/5/15

Merge

45

1/40

Jug/ac

1.13

315

7.88

354.375


In the producer, field and Acre columns, each lower cell equals the one above it so I don't have to repeatedly fill cells on my iPhone with the same information. For every field I spay I fill out a template of this spreadsheet. At the end of spraying I combine all of these spreadsheets into one large spreadsheet which I then want to sort by Product and then by producer.


Producer

Feild

Feild Operation

Date

Product

Product Cost

Rate

Rate Type

Cost/Ac

Acres

Total Product

Total Cost

GFL

Swalms

Spraying

5/14/15

Start up

5.7

1

L/ac

5.70

320

320.00

1824

GFL

Swalms

Spraying

5/14/15

Priority

560

1/160

L/ac

3.50

320

2.00

1120

BNG

Larry's Feild 4W

Spraying

5/13/15

Start up

5.7

1

L/ac

5.70

240

240.00

1368

BNG

Larry's Feild 4W

Spraying

5/13/15

Priority

560

1/160

L/ac

3.50

240

1.50

840

GFL

Daileys

Spraying

5/14/15

Start up

5.7

1/2

L/ac

2.85

150

75.00

427.5

GFL

Daileys

Spraying

5/14/15

Express

240

1/80

Jug/ac

3.00

150

1.88

450

BNG

35 North

Spraying

5/13/15

Start up

5.7

1/2

L/ac

2.85

235

117.50

669.75

BNG

35 North

Spraying

5/13/15

Express

240

1/120

Jug/ac

2.00

235

1.96

470

GFL

Chandlers

Spraying

5/13/15

Start up

5.7

1/2

L/ac

2.85

235

117.50

669.75

GFL

Chandlers

Spraying

5/13/15

Phix

90

1/320

Jug/ac

0.28

235

0.73

66.09375

GFL

Chandlers

Spraying

5/11/15

Start up

5.7

2/3

L/ac

3.80

40

26.67

151.99848

GFL

Chandlers

Spraying

5/11/15

Priority

560

1/160

L/ac

3.50

40

0.25

140

GFL

Nevagins

Spraying

5/11/15

Start up

5.7

92/123

L/ac

4.26

615

460.00

2622

GFL

Nevagins

Spraying

5/11/15

Priority

560

1/160

L/ac

3.50

615

3.84

2152.5

BNG

Reeta's West

Spraying

5/11/15

Start up

5.7

2/3

L/ac

3.80

290

193.31

1101.8898

BNG

Reeta's West

Spraying

5/11/15

Priority

560

1/160

L/ac

3.50

290

1.81

1015


This presents a problem because when i sort by the column product the producer and field cells begin to change their value and reference whatever cell they are below in the new sorted arrangement. Can I cut and paste the text or value in all the cells without texting and pasting the formula as well when I make a summary spreadsheet of my fields? This would eliminate cells referencing each other in my summary spreadsheet.


Thank you in advance for any advice

numbers-OTHER, iOS 6.1.3

Posted on Jun 30, 2015 6:35 AM

Reply
3 replies

How do I cut and paste the text or value in a cell without the formula?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.