moving data

**oilbath** · 11-03-2008, 05:09 PM

I would like to move a number from a group, automatically and post in a different colume. Like remove the 4 from 439 to a different colume. Any ideas?

oilbath

**mhuston** · 11-03-2008, 05:15 PM

=Left(source_string,number_of_characters) e.g. =Left(A1,1) in cell A2.

**oilbath** · 11-03-2008, 05:24 PM

Thanks, but where do I put all that data?

**mhuston** · 11-03-2008, 05:28 PM

That is the formula you put in the cell where you want the data to be, cell A2 in example.

**oilbath** · 11-03-2008, 06:17 PM

It spills across the whole page, where do I put the number I want to move

**mhuston** · 11-04-2008, 09:11 AM

I am confused. You said "Like remove the 4 from 439 to a different colume" The formula I gave you goes in the "different colume [sic]" and references the column where the 439 value is so if 439 is in cell a1 and you want 39 in cell a2, in cell a2 you place the formula [code] =Left(A1,1) [code]

**rwgrietveld** · 11-04-2008, 09:28 AM

Removes the 4 from 439

Please Login or Register  to view this content.

Removes all 4 from 346456

Please Login or Register  to view this content.

**oilbath** · 11-04-2008, 04:03 PM

I guess I wasn't very clear on what I wanted. Try this, on one day I have 489, would like to put each number in a different cell, the next day I have 324 would like to put the 3 and the 2 in there own cells, and the 4 in the cell with the first 4.

**rwgrietveld** · 11-05-2008, 03:42 AM

I've used the following code

Please Login or Register  to view this content.

Probably the exelsheet explains better. It counts the number of times a value is found.

**oilbath** · 11-05-2008, 12:09 PM

This doesn't seem to do the job I am looking for

**ChemistB** · 11-05-2008, 04:54 PM

I modified rwgrietveld's formulas with the REPT function to display each digit the number of times it appears between D3 and D50. Is this what you are looking for? If not, an example spreadsheet would do wonders.

**oilbath** · 11-05-2008, 07:01 PM

How do I attach my spreadsheet?

**teylyn** · 11-05-2008, 11:40 PM

How do I attach my spreadsheet?

When you reply to the thread, look below the big text box for "Additional Options", click the button "Manage Attachments", click the "Browse" button, find your spreadsheet, click OK, click Upload.

cheers

Teylyn