Hello all,
I feel like I have a very simple problem, but I can't figure it out. I need to get the values of multiple cells to display in one single cell. These values consist of both numbers and letters. For example, if cell R2 contains "K", S2 contains "F", T2 contains "54", and U2 contains "A", I would like cell J2 to display KF54A. I have tried to do the formula =R2,S2,T2,U2 but I return a VALUE error. How do I get this to happen?
Thank you so much for your help
Try
=R2&S2&T2&U2
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Try this in J2
Please Login or Register to view this content.
Happy to Help
VISHA
Click *, if the suggestion helps you!
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>> "Mark your thread as Solved"
That worked! Thank You!
Now, I'm having another problem, if the value of T2 is "01", only "1" is displayed. I have used the format cells > custom > 00 but it still doesn't work... I would like it to display a LETTER LETTER DIGIT DIGIT LETTER always, whether there is a zero or not. I have tried to enter ##00# but that doesn't do the trick
Last edited by ibsoxfan; 02-18-2013 at 06:01 AM.
In T2 your format is text?
In T2 my format is digits, but there are leading zeros in many of them, so when I would like the value of J2 to be KM03A, it is showing up as just KM3A
Try Text to column.
what does that mean?
In T2 my format is digits, but there are leading zeros in many of them, so when I would like the value of J2 to be KM03A, it is showing up as just KM3A
digit format with leading zeroes...?
Does this helps?
=IF(LEFT(T2,1)=0,R2&S2&0&T2&U2,R2&S2&T2&U2)
No, that still only displays the one digit without the leading zero...
Hi
select column T and right click on it and select format cells - number -text- ok.
That isn't an option on my excel, I can do format cells, but then cumber and text are two different things, so I can't select one in the other.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks