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 :p

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!

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.

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 :o

Thanks guys, both methods worked sweet!

[QUOTE=Bakks]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 :o[/QUOTE]

bit of a hijack.

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?

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$")

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.

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?

=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

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.