Hi!

Here's a formula method that requires an additional column.

In C1 enter this formula:

=LEFT(B1,FIND("""",B1)-1)&""""&LEFT(A1,FIND("
",A1)-1)&""""&MID(B1,FIND("""""",B1)+2,255)

Copy down as needed.

Biff

"Hayden Fox" wrote
in message ...

Sorry to have posted this in 2 places but after my first post I realized
that this board is the better one to post on as it states on the main
page.

Here is my problem.

In COLUMN A, there is a list of cells containing numeric & text
information. For example:

Column A/Row 1 = 123456 Keyboards, Black
Column A/Row 2 = 1234 Mice, Black
Column A/Row 3 = 12345 Monitors, Gray

In COLUMN B, there is a repeated list of text all the way down the
column. For example:

Column B/Row 1 = Text""Text
Column B/Row 2 = Text""Text
Column B/Row 3 = Text""Text

My goal here is to take the numeric portion from each cell in Column A
and place that numeric portion in between the Quotation Marks ("") in
the corresponding cell in Column B.

I tried to use the Help feature but after one hour of trying that still
have no luck. Please help me if you can. I will pay you back someday
somehow if you do.


--
Hayden Fox
------------------------------------------------------------------------
Hayden Fox's Profile:
http://www.excelforum.com/member.php...o&userid=30807
View this thread: http://www.excelforum.com/showthread...hreadid=504680