| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can this be done?
I want to take the data from these cells and display them together..
C D E F G 1 h 34 4 001 H|34|4|001 2 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can this be done?
how 'bout:
=c1 & " " & d1 & " " & e1 & " " & f1 & " " & g1 :) susan On Jan 13, 9:44*am, wrote: I want to take the data from these cells and display them together.. * C * * * * * * *D * * * * * * *E * * * * * * F * * * * * * * G 1 h * * 34 * * *4 * * * * * * *001 * * * * * H|34|4|001 2 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can this be done?
Hi
Try this : =C2&" "&D2&" "&E2. If you don`t want a space between each cell information, remove & with '' space '' HTH John. wrote in message ... I want to take the data from these cells and display them together.. C D E F G 1 h 34 4 001 H|34|4|001 2 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can this be done?
One way:
G1: =C1 & "|" & D1 & "|" & E1 & "|" & F1 or, if leading zeros in F are important (i.e., not Text): G1: =C1 & "|" & D1 & "|" & E1 & "|" & TEXT(F1, "000") In article , wrote: I want to take the data from these cells and display them together.. C D E F G 1 h 34 4 001 H|34|4|001 2 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can this be done?
according to your sample, you want to change h to H and with a pipe in between
the value in the columns, try this formula which will return the exact result provided by you. =UPPER(C1&"|"&D1&"|"&E1&"|"&"|"&F1) -- Your feedback is appreciate if this posting is helpful, pls click on the Yes button below Thank You cheers, francis " wrote: I want to take the data from these cells and display them together.. C D E F G 1 h 34 4 001 H|34|4|001 2 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can this be done?
pls use this as my previous post have an additional pipe
Place the below formula in G1 =UPPER(C1&"|"&D1&"|"&E1&"|"&F1) this will produce exactly H|34|4|001 in col G Does this do what you want? HTH -- Your feedback is appreciate if this posting is helpful, pls click on the Yes button below Thank You cheers, francis "xlmate" wrote: according to your sample, you want to change h to H and with a pipe in between the value in the columns, try this formula which will return the exact result provided by you. =UPPER(C1&"|"&D1&"|"&E1&"|"&"|"&F1) -- Your feedback is appreciate if this posting is helpful, pls click on the Yes button below Thank You cheers, francis " wrote: I want to take the data from these cells and display them together.. C D E F G 1 h 34 4 001 H|34|4|001 2 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can this be done?
Column F could contain a number that is formatted to show leading
zeros, rather than the text value 001. In that case, use this variation: =UPPER(C1&"|"&D1&"|"&E1&"|"&TEXT(F1,"000")) Hope this helps. Pete On Jan 13, 3:25*pm, xlmate wrote: pls use this as my previous post have an additional pipe Place the below formula in G1 =UPPER(C1&"|"&D1&"|"&E1&"|"&F1) this will produce exactly *H|34|4|001 in col G Does this do what you want? HTH -- Your feedback is appreciate if this posting is helpful, pls click on the Yes button below Thank You cheers, francis |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
