concatenate + format color [SOLVED] - Excel Help Forum
Sep 15, 2005 · A formula cannot be used to modifiy the format of a cell, it just returns a value. Excel (2002/2003) will allow you to part format the font of a cell if it contains text but not if it contains a …
merge text from 2 columns into 1 then delete the old 2 columns
Mar 30, 2006 · Re: merge text from 2 columns into 1 then delete the old 2 columns Thiem: I did the concatenate cell, however, when I deleted the old columns, I lost everything. It appears that the …
[SOLVED] Keep Percentage Formatting When Including Text - Excel …
Jan 19, 2024 · Forum Microsoft Office Application Help - Excel Help forum Excel General [SOLVED] Keep Percentage Formatting When Including Text The use of AI tools (e.g. chatGPT, BARD, GPT4 …
Keep formatting when concatenating [SOLVED] - Excel Help Forum
Mar 19, 2023 · Hi I need to combine text and number from 5 cell to 1 cell. All cells are special custom formatting with Type 00 to preserve "0" in front of a number. Eg. 02 My problem is A1= "1F" B1= "04" …
combine 2 cells but keep formating of each individual cell
Jul 7, 2006 · Re: combine 2 cells but keep formating of each individual cell can you please tell me how to make the formating for the text adn the numbers in the same cell? cant figure that out (sorry that I …
[SOLVED] VBA combine data and remove duplicates - Excel Help Forum
Oct 7, 2023 · I work in Excel all the time but am not a specialist in VBA. What is the goal - to have a macro that would combine data from two or more separate Excel files into a new file, pasting data …
Left Align Across Selection [SOLVED] - Excel Help Forum
Sep 10, 2012 · For instance: I'd like to fit text across A1:B:1. If I center across selection, it will fit the text to the width of the two cells up to my default font. What happens then is my columns (A:B) are a fixed …
CONCATENATE Cells Formated as fractions [SOLVED] - Excel Help Forum
Apr 27, 2006 · Use the text function to specify to Excel how you want the numbers formatted. Where you have F2, use TEXT (F2,"#/#"), etc. "Northcoast" wrote: > I want to concatenate several cells, some of …
Combine multiple columns into one removing blanks [SOLVED]
May 19, 2020 · Re: Combine multiple columns into one removing blanks Hi - Attached is a solution. First, I use a helper column to consolidate all of the columns into one column. Then I have a results …
How to merge cells after using "Format as Table" style [SOLVED]
Dec 19, 2015 · Re: How to merge cells after using "Format as Table" style I found t finally! After you format your table with excel "Format as Table" click on design. There you can remove "Header Row" …