Can this be done?

  • Thread starter Thread starter james.b.ivey
  • Start date Start date
J

james.b.ivey

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
 
Hi
Try this : =C2&" "&D2&" "&E2.
If you don`t want a space between each cell information, remove & with ''
space ''
HTH
John.
 
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")
 
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
 
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
 
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
 
Back
Top