Posted to microsoft.public.excel.misc

Vince

external usenet poster

Posts: 22

Picking figures out of a cell

Gary''s Student wrote:
If the final set of digits is always a three digit number, then:
=RIGHT(A1,3)*1
if not, then use Text to Columns

--
Gary's Student

Thumbs up! Thanks

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
insert date	Larry	Excel Worksheet Functions	28	July 15th 06 02:41 AM
Compiling macro based on cell values	simonsmith	Excel Discussion (Misc queries)	1	May 16th 06 08:31 PM
Urgent date/scheduling calc needed	jct	Excel Worksheet Functions	3	February 24th 06 01:36 AM
cell color index comparison	MINAL ZUNKE	New Users to Excel	1	June 30th 05 07:11 AM
Copy cell format to cell on another worksht and update automatical	kevinm	Excel Worksheet Functions	21	May 19th 05 11:07 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us