My spreadsheet has 5 columns, Name, Job, Customer Date and hours, Usually any given sheet has less than 10 lines. I would like to merge the data on each line and print them to labels.
- You could merge the text “values” in one cell with CHAR(10) as a helper (see: Excel formula: Add a line break with a formula | Exceljet)
- You can cut the lines and (paste special) insert as transposed: lines will change into columns
For further advice specify your question.
That is cool, thank you, it works to merge the data into a single cell. One of my lines however is the date, and when it merges that into the cell, it converts it back to its numeric value.
to specify, the date is an =today() function
The =TODAY() function can be transformed into desired text by =TEXT() function.
.
You could use this (example): =TEXT(D1;"DD-MM-YYYY")
Not every formatting code worked satisfactorily on my machine… and there could be some differences in locale. Try out. Another code which worked using full stops was =TEXT(D1;"DD"".""MM"".""YYYY") (a bit strange format, but the simpler one didn’t work).
That did it, thanks! I’m a mechanic by trade, I can navigate the basics of spreadsheets, but I’m pushing my skills into new territory here. All my data is in merged cells now. I will work with figuring out how to print to a label. Thanks for sharing your experience!