English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

Ok lets say in the first column you have a bunch of names. john henry, mike williams, carlos rivas etc. is there a way to arrange the entire column so that henry, john williams, mike rivas, carlos comes out?

2007-12-25 12:43:19 · 5 answers · asked by jason o 2 in Computers & Internet Software

ok horatio what i meant was that i want to rearrange the the names in the column. for instance, instead of mike williams, i want to change it to williams, mike. is there a way u can apply that to all the names in the entire column or you would have to do it yourself one by one?

2007-12-25 13:04:41 · update #1

Ok i tried that but it didnt work for me. Is there a way you can rearrange an entire column that way? I have thousands of rows.

2007-12-25 13:32:42 · update #2

Ok I didnt really get the exact answer I was looking for but expletive's answer helped me most and liked your advice. But thanks alot horatio and MYs, you also had great answers but i have a basic excel knowledge and got a lilttle confused lol. happy holidays guys

2007-12-25 14:26:45 · update #3

5 answers

hmmm? MY's answer didnt work for you?
i thought it was pretty awesome.
try like 5 names, it should work.

or try it the manual way:
highlight your column with names
-click data
-click text to columns...
-make sure delimited is checked click next
-make sure space has the check mark (may have to uncheck tab)
-click next, make sure it looks right, and you have a good destination
-click finish

so now you should have 1st name in column a, and last name in column b

then in column c use
=CONCATENATE(B1,", ",A1)

2007-12-25 13:52:18 · answer #1 · answered by expletive_xom 7 · 0 0

Looks like someone else came up with a solution before I could.

With MY's formula, you need to keep the original column intact. Working with the first name only, in an adjacent blank column, paste MY's entire formula into the first cell A2. Next copy that formula from that first cell. Then highlight the remaining blank cells all at once in that adjacent column and paste the formula.
When finished, then you can delete the original column if you like.

2007-12-25 12:52:09 · answer #2 · answered by Horatio 7 · 0 0

an option to John's answer is to concentration on the two columns, then circulate to documents>kind and kind by applying column B. in case you have column headings which contain 'place' and 'date', determine you tick the container that pronounces some thing like 'my documents has headers' and then basically the suggestions under will kind. this could save places in column A and dates in column B.

2016-10-09 04:23:46 · answer #3 · answered by ? 4 · 0 0

Follow MYs’ instruction. MYs unquestionably knows how to Excelling.

2007-12-25 17:00:16 · answer #4 · answered by Buzz 2 · 0 0

cell A1: mike williams
cell A2: williams, mike
enter this formula in cell A2:

=RIGHT(A1,LEN(A1)-
FIND("*",SUBSTITUTE
(A1," ","*",LEN(A1)-
LEN(SUBSTITUTE
(A1," ","")))))
&", "&
LEFT(A1,FIND(" ",A1,1))


Good luck.

2007-12-25 13:14:51 · answer #5 · answered by MYs 5 · 2 0

fedest.com, questions and answers