tag:blogger.com,1999:blog-32201214.post87488625629720690..comments2023-08-03T07:25:18.861-05:00Comments on Stremmed Out: Another Goodbyestremhttp://www.blogger.com/profile/07607081379914875059noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-32201214.post-37071202815122074472007-10-15T13:21:00.000-05:002007-10-15T13:21:00.000-05:00Don't be embarrassed. Hopefully, your version will...Don't be embarrassed. Hopefully, your version will work like that. <BR/><BR/>Of course, I don't know anything about your type of web documents. But, for other merges, when you pull information from the spreadsheet, it is often easier to add the extra words and punctuation in the merge instead of altering it in the spreadsheet. I was wondering if this was applicable in your case. Just depends on how you're converting the information.stremhttps://www.blogger.com/profile/07607081379914875059noreply@blogger.comtag:blogger.com,1999:blog-32201214.post-31379184861072836022007-10-15T12:49:00.000-05:002007-10-15T12:49:00.000-05:00Are you serious? That's it?! Well, now I'm just ...Are you serious? That's it?! Well, now I'm just embarrassed. I spent a lot of time trying to figure that out.<BR/><BR/>I was using it to convert some spreadsheets into a format where I could upload the info into a database on a webserver.Jeremy Sarberhttps://www.blogger.com/profile/13653866782856745133noreply@blogger.comtag:blogger.com,1999:blog-32201214.post-27543389660219447442007-10-15T11:46:00.000-05:002007-10-15T11:46:00.000-05:00No....you copy the formula. You just click on the ...No....you copy the formula. You just click on the first cell to which you want to apply it, drag your mouse down to start highlighting, keep dragging down until you've highlighted your last cell to which you want to apply it, and then press paste. It copies it to the entire group of cells at one time. Just takes seconds.<BR/><BR/>Either way, we should talk about this. Depending on the reason you want it this way, there may be an easier solution.stremhttps://www.blogger.com/profile/07607081379914875059noreply@blogger.comtag:blogger.com,1999:blog-32201214.post-87253128065123472852007-10-15T11:23:00.000-05:002007-10-15T11:23:00.000-05:00Yeah, I actually had that figured out but since I'...Yeah, I actually had that figured out but since I've got 3,000 rows I was hoping to find an easier way. Otherwise, I have to copy and paste that 3,000 times and that's not including the many other sheets with 3,000 on each.Jeremy Sarberhttps://www.blogger.com/profile/13653866782856745133noreply@blogger.comtag:blogger.com,1999:blog-32201214.post-51389997306871677162007-10-15T11:09:00.000-05:002007-10-15T11:09:00.000-05:00FYI. The weird symbols above are ampersands. This ...FYI. The weird symbols above are ampersands. This font makes them look strange.stremhttps://www.blogger.com/profile/07607081379914875059noreply@blogger.comtag:blogger.com,1999:blog-32201214.post-64935616792547100022007-10-15T11:07:00.000-05:002007-10-15T11:07:00.000-05:00If your last names are in column A and your first ...If your last names are in column A and your first names are in column B, make a temporary or permanent column C by inserting a column. If your first name combo appears on row number 2 (with header row on row 1), go to cell C2 and type or copy the following formula:<BR/><BR/>=A2&", "&B2<BR/><BR/>Please note there is a space after the comma inside the quotes that is necessary to create the space in your desired result.<BR/><BR/>Then copy the formula in that cell for all of the other cells in that Column C, and Excel will figure out the rest to apply it consistently in the other rows. If you need more help or more explanation on this, let me know. Hope this works out for you. :)stremhttps://www.blogger.com/profile/07607081379914875059noreply@blogger.comtag:blogger.com,1999:blog-32201214.post-52332590420843742052007-10-13T13:06:00.000-05:002007-10-13T13:06:00.000-05:00So, you're a Microsoft Office expert? I have a qu...So, you're a Microsoft Office expert? I have a question about Excel. Can I combine columns while simultaneously inserting something between the data in those combined columns? For instance, if I have column A with "Smith" in it, and column B has "John," can I combine them into one column and have it say "Smith, John?" I racked my brain on that one awhile back but eventually gave up.Jeremy Sarberhttps://www.blogger.com/profile/13653866782856745133noreply@blogger.com