Ok,
Say that I am using row 1 through Column E.
I am putting in steel information. Something like this. In steel L
stands for Angle. L 1/4 x 4 x 4. That will be the detail information.
That will fit into cell A1. Then the length will fit into Cell B1. All
other information will put into the remaining cells. I want those cells
to count as a block. The same thing will continue will row 2. This will
count as a block as well. So on and so on. Except say that, I enter
information into row 2 as a channel instead of an angle. That would be
C8 x 15. Well, I am not putting the information in any certain order as
I am doing data entry. When I am done with the data entry. I want to go
back and sort it so the angle and channel all end up together in there
own groups.
No difference, once you concatenate they will all be text regardless if you
treat one cell as a number
if all cells are numbers (most unlikely) one could use
=--(A3&B3&C3&D3&E3&F3)
however if there is a single text character in the above it will return a
value error so your formula won't do any difference at all
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
