Jack Taylor

Posts: n/a

Bringing partial data from one cell into another

I believe that there is a way to bring part of the data
from one cell into another, but I sure can't find the
correct function to make this happen. For example:

"year 2005" is contained within cell A1 and I would like
to bring only "2005" into cell B3.

Does anyone know the formula to make this happen?

Thanks!
JT

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
Import Data into same cell	ib_redbeard	Excel Discussion (Misc queries)	3	March 1st 05 12:08 PM
I want a window to cell data that conains links to PDF files and .	WEATHER TECH. NOT A ROCKET ENGINEER	Excel Discussion (Misc queries)	1	February 24th 05 08:21 PM
Repeat Cell Data	Pinky	Excel Worksheet Functions	1	January 18th 05 05:38 PM
Finding Partial Text in a Cell	bob	Excel Worksheet Functions	6	December 18th 04 05:03 AM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM

All times are GMT +1. The time now is 02:33 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us