Monday, January 11, 2016
How to concatenate or join columns value in excel
Sometimes there is a need to join or concatenate columns value that comes from different column. And of course to make the joined value most often we use underscore to identify the value comes from different columns
Cell A1 = Bobby
Cell B1 = Mark
Let say you want to concatenate Bobby and Mark name using underscore from Cell A1 and B1. Simply use the following command;
The result yields = Bobby_Mark
One simple circuit to step up voltage using LM2577 -Adj P+ chip. The schematic is from Texas Instrument and it works expected - and below is...