Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Excel =Concatenate

Comment:

Hi, I am using concatenate and it looks something like this. =CONCATENATE(C6,B6,B7,B8,B9), then I go in and add " ", to add spaces between each number so it looks like this =CONCATENATE(C6," ",B6," ",B7," ",B8," ",B9). Sometimes there are 100 or more cells I am selecting, I would like to use shift, but then it looks like this =CONCATENATE(B4:B127), how do I add spaces to a range? Thank you so much!

Outlook Contacts

Supercalc 4

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Concatenation is not what you want for this data. I would just import the data into Access and create a Report to generate your Invoice. That would be much, much easier and simpler. Soylent Green is...

Summary: Concatenate (combine) Header Row with Variable Number of Detail Rows I need help writing an Excel VBA routine. My input worksheet consists of rows, with 1 cell in each row, in the following format: He...

Summary: What version of Excel do you have? If you have 2003, there is a "Merge Cells Wizard" add in available. Or, you could use the "Concatenate" function. Soylent Green is PEOPLE!!! ...