Excel disable auto increment in formula by row and column
=CONCATENATE(J29,$H29,"mmm") If you want to copy across, but always refer to H29. =CONCATENATE(J29,H$29,"mmm") If you want to copy down, but always refer to H29. =CONCATENATE(J29,$H$29,"mmm")If you want to copy down and across, but always refer to H29. $h29 -> places dollar before column disables auto increment in column h$29 -> places dollar before row disables auto increment in row $h$29 -> places dollar before row and column disables auto increment in row & column. Was very hard to find out that. src http://forums.techarena.in/windows-software/1181179.htm