Posted to microsoft.public.excel.worksheet.functions

Jennifer

external usenet poster

Posts: 3

How do I get the last 7 characters of a no. to another column?

I need to get the last 7 characters of a number in one column to another
column so I can sort them. The number is in the format 00-1234-12.

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
Set the number of characters in a column	bicheno	Excel Discussion (Misc queries)	0	March 28th 07 02:14 AM
Set the number of characters in a column	Stefi	Excel Discussion (Misc queries)	0	March 28th 07 01:19 AM
How do I cut column back to first 2 characters? Thanks	Dave	Excel Discussion (Misc queries)	1	May 5th 06 05:24 AM
Get max characters in cell in 1 column	fbonilla	Excel Discussion (Misc queries)	3	February 28th 06 10:39 PM
vlookup first 4 characters only in a column	Gus	Excel Discussion (Misc queries)	6	February 20th 05 04:41 PM

All times are GMT +1. The time now is 05:04 AM.

About Us

"It's about Microsoft Excel"