Excel formatting

Closed
jay - 17 Feb 2010 à 09:42
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 17 Feb 2010 à 23:19
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
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
17 Feb 2010 à 23:19
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