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