Adding to the text in a range of cells.

[Frank Z]

I've got a spead sheet containg 10,000 parts in cells A2 through A10001

I need to break up these into smaller groups (1k each) by adding GRP1/, GRP2/, GRP3/, etc to the text that's already in the cells.

Is there a Function that will do this for me?

 

[Brian from Maui]

You could try

="GRP1/"&A1

and copy down

 

[Frank Z]

You could try

="GRP1/"&A1

and copy down

Maybe I'm not doing it right.
I aded your info to the cell and tried to drag the rang that i needed.... no luck.

 

[Brian from Maui]

If the range to add the text is in A2:A10001, in B2 enter,

="GRP1/"&A2

and copy down.

Now the question is, what criteria is used to determine what's in GRP1, GRP2 or GRP3?

 

[Frank Z]

Just quantity.

 

[Frank Z]

If the range to add the text is in A2:A10001, in B2 enter,

="GRP1/"&A2

and copy down.

Now the question is, what criteria is used to determine what's in GRP1, GRP2 or GRP3?

That works, but it places the data in the same cell that the formula was placed in.

I need to add the GRP# to the text in A1 through A10001, and keep it in those cells.

 

[Frank Z]

Cut and past?

 

[Brian from Maui]

Cut and Paste Special / Values

Post your criteria and we can group it according to your criteria with a formula.

 

[Frank Z]

Criteria is pretty straight forward.
I've got a spreadsheet that contains a list of 10k part numbers. The part numbers need to be seperated into groups of 1000 by adding the aforementioned text to the font of the number. The spread sheet is saved at a later time as tab delimited text file. The prefix that is being added will seperate the the overall list into manageable sizes for insertion into a database.

Make sense?

 

[Brian from Maui]

Ahhhh not to me.


What criteria places it in GRP1, GRP2 and GRP3? What differentiates a part from GRP1 or GRP2 or 3? Is it the first 1000 in GRP1, the next 1000 in GRP2 etc.?