modify excel spreadsheet

[smartkid808]

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

[DustinB3403]

Are you simply trying to combine the 3 cells IE 00300, 300 and 1025 to be 300.300.1025

?

[Kelly]

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

[smartkid808]

@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.

[DustinB3403]

@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]

[DustinB3403]

@dustinb3403 said in modify excel spreadsheet:

Just setup the formula for a single row, and copy it to cover the entire spreadsheet.

[smartkid808]

Awesome.. Thanks guys. Looks like that will work.. I've sent that over for them to review. appreciate the help and quick response.

[thwr]

A shorter alternative to CONCATENATE

=A1 & "." & B1 & "." &C1

[thwr]

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")