How do you do....it? Thread, Excel Formula in Technical; Hi,
I am shortly going to be importing all the new intake for September into the AD, and using a ...
6th July 2009, 09:09 AM #1
- Rep Power
IDG Tech News
6th July 2009, 09:17 AM #2
if you have 3 columns:
y9 bloggs joe
etc... then the following formula will stick em together and add the first char in:
Thanks to localzuk from:
Pumaedition (6th July 2009)
6th July 2009, 09:47 AM #3
- Rep Power
super job! That'll do nicely! cheers!
I have been playing, but couldn't get it quite right!
8th July 2009, 05:48 AM #4
Using =CONCATENATE() can help as well.
8th July 2009, 08:49 AM #5
If you could copy and paste a couple of rows from the csv and put that into a new csv and change the end user names / details etc and then upload that after to here we can see the output and amend that.
Originally Posted by localzuk
If you do have column 1 with year9 or yr9 or something else then obviously that will need re formatting.
Other then that the above should work fine ( and that's how I would of done it as well )
8th July 2009, 09:46 AM #6
The formatted names will be stored as a formula so you may want to copy that column to another one using Paste Special and selecting value. You can then delete the other columns that you don't need. I also use Excel to check for duplicates and correct them within Excel rather than having the import program decide how they will be differentiated.
Last edited by laserblazer; 8th July 2009 at 09:49 AM.
8th July 2009, 09:52 AM #7
I use something similar that deals with a middle initial
[Display] Name: Joe P Bloggs [Excel Cells A1, B1 & C1)
Formula for username:
Formula for displayName:
The first formula converts the username to lowercase, uses the first letter of A1. It then checks to see if B1 contains any data, if it DOES then it includes the inital in B1 and the surname in C1, if B1 is empty, then it only displays the surname..
=A1&(IF(B1<>""," "&B1&" "&C1," "&C1))
The second formula is very similar to the first, but inludes spaces around the initial or before the surname - depending on the value of B1
I use this in conjunction with a SIMS export and WiseSofts AccountManagement Spreadsheet..
By leco in forum Office Software
Last Post: 3rd July 2009, 11:43 AM
By park_bench in forum Office Software
Last Post: 8th May 2009, 05:24 PM
By denon101 in forum How do you do....it?
Last Post: 1st December 2008, 04:34 PM
By RabbieBurns in forum Windows
Last Post: 13th August 2008, 06:31 PM
By DSapseid in forum Windows
Last Post: 7th November 2007, 05:56 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)