Can this be done?

[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

 

[Susan]

how 'bout:

=c1 & " " & d1 & " " & e1 & " " & f1 & " " & g1


susan

 

[John]

Hi
Try this : =C2&" "&D2&" "&E2.
If you don`t want a space between each cell information, remove & with ''
space ''
HTH
John.

 

[JE McGimpsey]

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")

 

[xlmate]

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

 

[xlmate]

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

 

[Pete_UK]

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