I am working on a google spreadsheet and I combined three data ranges into one range by using CONCATENATE Function but when I am combining the data in one single cell the problem is occurring that I can't get a proper alignment in it because the number of digits in the first cell is fluctuating.
Allignement Problem
- Thread starter Sonam@456
- Start date
Sonam@456
Have You checked its syntax?
There is one possible solution:
Use the TEXT function to combine and format strings.
Important: In Excel 2016, Excel Mobile, and Excel for the web, this function has been replaced with the CONCAT function. Although the CONCATENATE function is still available for backward compatibility, you should consider using CONCAT from now on. This is because CONCATENATE may not be available in future versions of Excel.
Have You checked its syntax?
There is one possible solution:
Use the TEXT function to combine and format strings.
Important: In Excel 2016, Excel Mobile, and Excel for the web, this function has been replaced with the CONCAT function. Although the CONCATENATE function is still available for backward compatibility, you should consider using CONCAT from now on. This is because CONCATENATE may not be available in future versions of Excel.
GraH - Guido
Well-Known Member
You would be needing to use a monospaced font type (like Courier) too.
Excel does not print the tab character (CHAR(9)) inside the cell. At least I tried, and it did not work.
Excel does not print the tab character (CHAR(9)) inside the cell. At least I tried, and it did not work.