Posted to microsoft.public.excel.misc

Bobby[_3_] Bobby[_3_] is offline

external usenet poster

Posts: 6

Reversing text

I have a column formatted as text, I want to reverse the numbers around
a1 1 a1 5
a2 2 a2 4
a3 3 will look like this a3 3
a4 4 a4 2
a5 5 a5 1
Take #5 and move it up to row a1 #4 move to row a2 #3 stays put, #2 move it
to a4 and #1 move to a5. Can this be done with Excel. I need it simple.
Thanks Bob

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Reversing the log	Charli B	Excel Discussion (Misc queries)	6	July 16th 08 11:11 AM
Reversing Text in cells	Truc Lopez	Excel Discussion (Misc queries)	4	January 14th 08 07:36 PM
Reversing Data	Peter[_8_]	Excel Discussion (Misc queries)	1	December 14th 07 04:00 AM
Reversing a column. How?	[email protected]	Excel Discussion (Misc queries)	5	December 21st 06 09:04 PM
Reversing First & Last Name	Magic	Excel Worksheet Functions	3	April 6th 05 08:18 PM

All times are GMT +1. The time now is 09:27 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us