Excel formatting

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hey All,

I have a column of data in excel for example as below;

ABC
DEF
GHI
JKL
MNO

The list is faily exhaustive and I need to format the above (somehow) to read as below;

ABC+DEF+GHI+JKL+MNO

If anyone knows how I would be really greatful for their help, please.

Thanks, Jay

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
depends on how long is the list, but a starter could be

lets say value start from a2, then in b2 you can use some thing like

=a2 & " + " & a3 & " + " & a4 & " + " & a5