98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » EXCEL SPREADSHEET
EXCEL SPREADSHEET
Resolved · Urgent Priority · Version 365
Mon 27 Mar 2023, 13:38Delegate Helen said...
Helen has attended:
Excel Introduction course
EXCEL SPREADSHEET
MERGING SPREADSHEET WITHOUT LOSING THE VALUES ON EACH ROW.
I GET AN ERROR MESSAGE SAYING MERGING CELLS ONLY KEEP THE UPPER-LEFT VALUE AND DISCARDS OTHER VALUES.
Mon 27 Mar 2023, 16:47Trainer Jens said...
RE: EXCEL SPREADSHEET
Hi Helen,
Thank you for the forum question.
First of all, merge cells is not a good idea in Excel. This can give you a lot of problems with other Excel tools.
Yes and if you merge cells and you have text or numbers in the cells, Excel will only keep the data from the first cell and delete the data from the rest of the cells.
I do not know what you want to do.
If you want to concatenate the content from many cells into on cell, you can do it by a formula.
If you have text in A1, A2, and A3 and want the text concatenated in B1. Select B1 and type:
=A1 & " " & A2 & " " & A3
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Tue 28 Mar 2023, 10:40Delegate Helen said...
RE: EXCEL SPREADSHEET
Morning, thanks for your reply, the formula did not work for me.
I have a spread sheet in excel with 30 rows of bus numbers going down in one column and next to each bus number i have a text in each row relevant to each bus number.
I am getting this information from a generated spreadsheet and copying and pasting info from that spread to my spreadsheet.
My spread sheet is unmerged, it has inserted the values in all the cells on one row saying the same thing, when i press merge and center it comes up with error MERGING CELLS ONLY KEEPS THE UPPER-LEFT VALUE AND DISCARDS OTHER VALUES, which is fine as that row has merged with the relevant text in it. But
I have 30 - 40 rows of this on 7 spreadsheets and doing this individually is time consuming.
Question: How do I merge each row without having to do it individually and keeping each row with its relevant text and not just the text value at the top? Is this possible.
hope you understand this.
Regards
H
Wed 29 Mar 2023, 10:18Trainer Jens said...
RE: EXCEL SPREADSHEET
Hi Helen,
Sorry it is still not clear to me what you want.
If it is that you have all the text in one column and you want to split it across many columns, you can select the column with all the text and use the tool on the Data tab Text to Columns.
I am happy to have a look at your Excel file. Then it will be easier for me to guide you to the best solution.
You can send the file to:
info@stl-training.co.uk
Please write that the file is for Jens
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Wed 29 Mar 2023, 10:44Delegate Helen said...
RE: EXCEL SPREADSHEET
Thanks for info, i managed to work it out.
Simply really, instead of copying all text across spreadsheet and trying to merge & center, i just put in the first column. Then highlighted rest of the spreadsheet were i wanted my text to go.
went to merge & center, drop down arrow and selected merge across.
This enabled me to merge text in multiple rows without losing relevant data in multiple rows.
Thank for your reply.
H.
Wed 29 Mar 2023, 10:47Trainer Jens said...
RE: EXCEL SPREADSHEET
Hi Helen,
Sorry I was not very helpful, but I am happy that you found a solution.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Create a hyperlink navigation sheetIn large files, it is often useful to have a front sheet with hyperlinks to the key databases and summary calculations in your spreadsheet. Hyperlinks can save you and (more importantly) those less familiar with your spreadsheet a great deal of pointless scrolling between and within sheets. |
