Immediate Help Needed - Excel Newbie **remove last comma in sum

[jamesdor45]

Hi Guys!

Great board and the answers I found here helped me on many occasions.

I’m an excel newbie and I have a stupid question that unfortunately I couldn’t make or solve, and I really need your help here.

I need to make a simple formula that will remove the last comma(s). For example, I have 7 lines (B1 – B7) that I insert a text into those. I then have another line (B8) that will show all of this words (including the commas). However I wont always have to insert all 7 options, so in some scenarios where I have to fill only two lines (B1 and B2) then I will get all of the commas from all other lines (B3 – B7).

The formula I currently use for A8 is this:


=B1&","&B2&","&B3&","&B4&","&B5&","&B6&","&B7


Can you guys please help me here? I really need this find a solution for this as soon as possible.

Thanks again for your time!

Regards,
Jerry

 

[jamesdor45]

Guys, thank you so much for the help and swift replies. Rick solution is PERFECT and works great according to out needs. Peter, your formula does the same exact job, only that as you mention we will always have to insert a value in cell B1.

Thanks again for helping an excel newbie!

Regards,
Jerry

 

[pjmorris]

Thanks for the feedback Jerry, its appreciated.

If you wanted to use my expression you could enter the following in another cell: =right(b8, len(B8)-2); of course you could replace the references to B8 with the original formula, but I thought that to be too unweildy.

Regards