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/enus/article/combinetextfromtwoormorecellsintoonecell81ba0946ce7842edb3c321340eb164a6

@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)) + C1
Apply a cell data format of
000\.000\.0000
or use the TEXT function=TEXT((A1*(10^7)) + (B1 * (10^4)) + C1; "000\.000\.0000")