Solved excel username policy formula

Custom / CUSTOM
June 4, 2011 at 14:16:44
Specs: Server 2003, 3.401 GHz / 4072 MB
How can i in excel make a username policy so excel take the first 2 letters from one cell and 3 letters from another cell and put them into 1 cell like this
Martin Hansen = mahan


See More: excel username policy formula

Report •


#1
June 4, 2011 at 15:39:44
✔ Best Answer
If your data looks like this:

      A          B         C
1) Martin     Hansen

Then in cell C1 enter the FORMULA: =LEFT(A1,2)&LEFT(B1,3)
and you will get:

      A          B         C
1) Martin     Hansen     MaHan

MIKE

http://www.skeptic.com/


Report •

#2
June 4, 2011 at 16:47:38
Thanks it works, what about getting it lower case?


Report •

#3
June 4, 2011 at 17:16:21

=LOWER(LEFT(A1,2)&LEFT(B1,3))

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
June 5, 2011 at 02:05:34
In excel 2010 its ";" instead of ","

=LOWER(LEFT(B2;2)&LEFT(C2;3))

But thanks for a quick and correct answer!


Report •

#5
June 5, 2011 at 03:22:17
re: In excel 2010 its ";" instead of ","

Not in any version of 2010 I've used.

OpenOffice uses semi-colons, Excel use comma.

What strange version of 2010 are you using?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#6
June 5, 2011 at 03:25:55
hmm sounds wired, is where a way to reset all settings?


Report •

#7
June 5, 2011 at 07:53:06
I believe European and/or Asian versions of Excel use the Semicolon as separators.
I've seen them used in the past here on the forums, but not often.

So, Martinohansen, where are you located, the US?

MIKE

http://www.skeptic.com/


Report •

#8
June 5, 2011 at 07:56:15
Europe, Denmark ? :)

Report •

#9
June 5, 2011 at 08:09:10
Goede Dag,

If you wish, you can changed it to the more common comma separator, as this is a function of the Windows OS.
Why they make the European separator one thing and the US another is one of those deep dark secrets that only Bill Gates knows.

To change:

Click Start
Click Control Panel
Click Regional and Language Options
Click the Customize button in the center of the pop-up window.
Now, where it reads Line Separator about 8 slots down,
change it from the semicolon to a comma.

MIKE

http://www.skeptic.com/


Report •


Ask Question