How to have Column in a table automatically fill specific text when a new row is added?

[Jfreshh330]

Hello all,

I have a table in the below images so that when I fill out the fields in columns B, D, F, H, J, L, & M, that the formula in Column N will take each of those cells in that row and add an underscore "_" between them. In row 2 I have an example of the end result (N2)

I have to manually add in the underscores in each column for each new row so I was wondering if there is a way to automatically fill the cell with a _ when a new row is added to the table? (I know I don’t need to have multiple columns for the underscores _ I just did it this way to show how the formula would calculate it.)

Also in Column A, where I have each line numbered, whenever I add a new row by typing the next cell down in column B, that in Column A, it would automatically auto fill the numbers. I made sure I had everything checked in the AutoCorrect options as well.

Any advice?

Thank you!

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Jfreshh330]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Ahh I didnt even notice that, thanks! I’m using Excel 2016 16.0.13801.20772 for Windows 10.

 

[Fluff]

In that case rather than having a load of columns with just an underscore, why not use the Concatenate function like

=B2&"_"&D2&"_"&F2

but using structured references rather than ranges.

 

[Jfreshh330]

In that case rather than having a load of columns with just an underscore, why not use the Concatenate function like

=B2&"_"&D2&"_"&F2

but using structured references rather than ranges.

Omg thank you! This probably seemed obvious for a lot of you but I’m still learning ?

 

[Fluff]

Glad to help & thanks for the feedback.