I have information in three columns (A,B,C) on an Excel spreadsheet. I need to consolidate these three columns into one column (D). I need Excel to only pull the first 10 characters of column B when consolidating. Is this possible?
Computer OS: Mac OS X
I should be able to help you on this
can you provide the file you have ?!
Sure. how do I send it to you.
go to wikisend.com and upload the file you have, when done, post here the link they provide
http://wikisend.com/download/641880/class schedule sample.xlsx
so let me see if understand you correct
for example for first row what do you want in cell D?
AME 101L Introducti Paul Ronney
I think that's perfect!
ok one sec..
do you know how to enter a formula for a cell?
use this for D1 cell
=A1&" "&LEFT(B1,10)&" "&C1
than apply it for all cells in the d column
okay. one more thing. If I decide to increase the # XX characters in column B, do I simply change the 10?
What if I want to only use a few characters in column C? Let's say the first 5. How would I do that?
instead of C1 you will type LEFT(C1,5)
thus the formula will become:=A1&" "&LEFT(B1,10)&" "&LEFT(C1,5)
Okay great thank you so much! do I hit accept to pay you? You saved me today!
have a nice day
please do click accept button
Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.