|
Register | Diddy Kart | Articles | All Albums | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
LinkBack | Thread Tools | Display Modes |
#1
|
||||
|
||||
Need help excel nerds!
Ok Yes I did try and google... for like 10 seconds but found this easier so all of you people that will write search in google, get rooted
Ok so I have an excel document that has a cell with a full name lets say the name is Perth WRX How do I run a formula to grab the 2nd word being WRX of course and move it one cell to the right? So then I can have two cells one with First Name and the 2nd with Last Name Thanks! |
#2
|
||||
|
||||
Not sure on a formula... But this is what I do
Select the cells you want. Click 'Data' then 'Text to Columns' Choose 'Delimted' Choose the delimiter type (i.e. a space or a comma) Click Finish Presto, now it is in 2 columns.
__________________
[COLOR="Gray"]550Nm off a 2L... Just wish it was in the dak dak...[/COLOR] |
#3
|
||||
|
||||
If Perth WRX was in cell A1, you'd go =right(A1,3)
A1 being the cell reference, and 3 being the amount of characters from the right you want in your destination cell. Alternatively for Perth, it'd be =left(A1,5) Or you could do the above |
#4
|
||||
|
||||
Thanks guys, both methods worked sweet!
|
#5
|
||||
|
||||
Quote:
but is there a way in excel to add things to cells? at work i am the CAD Administrator and often go into computers to add thigns to preference files. the path to a computer is something like \\AU-D01234\D$ is there a way where i could just type in 1234 and the rest would link to it and make it a hyperlink?
__________________
[WREXX] 2005 Club Spec Evo 8 |
#6
|
||||
|
||||
Don't know on the hyperlink side of things...
But to join text you can use the CONCATENATE function. So for your example, put this in A1 and your '1234' in D1 =CONCATENATE("\\AU-D0",D9,"\D$")
__________________
[COLOR="Gray"]550Nm off a 2L... Just wish it was in the dak dak...[/COLOR] |
#7
|
||||
|
||||
You could also click on format cell create a custom text field and have the \\AU-D0 complete for you. Then in the next cell just have \D$
Then Copy paste it to notepad and delete the space between \\AU-D01234 \D$ and bang I used to do that heaps. |
#8
|
||||
|
||||
Ok one for the excel nerds (brain isn't working today):
I have a list of items that are used multiple times. i.e. PD1 PD4 PD4 PD4 PD4 PD5 PD1 etc Each item number is used mutliple times throughout. What I want to do is just have a summary of the items used. i.e. PD1 PD4 PD5 What's an easy way to do this?
__________________
[COLOR="Gray"]550Nm off a 2L... Just wish it was in the dak dak...[/COLOR] |
#9
|
||||
|
||||
=IF(range="PD1", 1,0)
Summate the column where 1 or 0 appears and it will give you the total of PD1 or PD2, etc Lazy way of doing it but there's another way, think its collate which i can't remember the exact steps |
#10
|
||||
|
||||
Ta Joe, but there are about 450 individual items on the list in about 3000 rows. I just want a list of the individual items, not worried about the total of them.
Interestingly with a filter they are all listed in the drop down box, but I just need that in some cells instead.
__________________
[COLOR="Gray"]550Nm off a 2L... Just wish it was in the dak dak...[/COLOR] |
Tags |
excel, google fail, nerds |
Thread Tools | |
Display Modes | |
|
|