Previous Topic Next Topic

Excel formatting

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

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 17, 2010 at 11:19 PM
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
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses