modify excel spreadsheet
-
Our accounting dept is trying to do the following. Any suggestions as I would think there is a way, its just how would it be done? Excel Macro?
Below is a download which separates the acct # into 3 separate fields. Can the fields be manipulated so the it is in the format in red? There are hundreds of accounts we need to do this for. I have no clue how to word a google search. lol thanks for any help
-
Are you simply trying to combine the 3 cells IE 00300, 300 and 1025 to be 300.300.1025
?
-
You can concatenate the contents of two or more cells into another cell with either the Ampersand or the Concat command.
https://support.office.com/en-us/article/combine-text-from-two-or-more-cells-into-one-cell-81ba0946-ce78-42ed-b3c3-21340eb164a6 -
@dustinb3403 Yes, from what I am understanding. There is alot more columns, and hundreds of rows. Above is all I was told.. I am waiting on more info, and the actual spreadsheet.
-
@smartkid808 said in modify excel spreadsheet:
@dustinb3403 Yes, from what I am understanding. There is alot more columns, and hundreds of rows. Above is all I was told.. I am waiting on more info, and the actual spreadsheet.
If so then yea just us the concatenate function.
-
-
@dustinb3403 said in modify excel spreadsheet:
Just setup the formula for a single row, and copy it to cover the entire spreadsheet.
-
Awesome.. Thanks guys. Looks like that will work.. I've sent that over for them to review. appreciate the help and quick response.
-
A shorter alternative to CONCATENATE
=A1 & "." & B1 & "." &C1 -
And now - just for science
If all fields are numbers and always have the same length (3/3/4):
=(A1*(10^7)) + (B1 * (10^4)) + C1Apply a cell data format of
000\.000\.0000or use the TEXT function=TEXT((A1*(10^7)) + (B1 * (10^4)) + C1; "000\.000\.0000")
