software

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 amp; 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 = Textquot;quot;Text
Column B/Row 2 = Textquot;quot;Text
Column B/Row 3 = Textquot;quot;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 (quot;quot;) 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: www.excelforum.com/member.php...oamp;userid=30807
View this thread: www.excelforum.com/showthread...hreadid=504680Hi!

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

In C1 enter this formula:

=LEFT(B1,FIND(quot;quot;quot;quot;,B1)-1)amp;quot;quot;quot;quot;amp;LEFT(A1,FIND(quot;
quot;,A1)-1)amp;quot;quot;quot;quot;amp;MID(B1,FIND(quot;quot;quot;quot;quot;quot;,B1) 2,255)

Copy down as needed.

Biff

quot;Hayden Foxquot; gt; wrote
in message ...
gt;
gt; Sorry to have posted this in 2 places but after my first post I realized
gt; that this board is the better one to post on as it states on the main
gt; page.
gt;
gt; Here is my problem.
gt;
gt; In COLUMN A, there is a list of cells containing numeric amp; text
gt; information. For example:
gt;
gt; Column A/Row 1 = 123456 Keyboards, Black
gt; Column A/Row 2 = 1234 Mice, Black
gt; Column A/Row 3 = 12345 Monitors, Gray
gt;
gt; In COLUMN B, there is a repeated list of text all the way down the
gt; column. For example:
gt;
gt; Column B/Row 1 = Textquot;quot;Text
gt; Column B/Row 2 = Textquot;quot;Text
gt; Column B/Row 3 = Textquot;quot;Text
gt;
gt; My goal here is to take the numeric portion from each cell in Column A
gt; and place that numeric portion in between the Quotation Marks (quot;quot;) in
gt; the corresponding cell in Column B.
gt;
gt; I tried to use the Help feature but after one hour of trying that still
gt; have no luck. Please help me if you can. I will pay you back someday
gt; somehow if you do.
gt;
gt;
gt; --
gt; Hayden Fox
gt; ------------------------------------------------------------------------
gt; Hayden Fox's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30807
gt; View this thread: www.excelforum.com/showthread...hreadid=504680
gt;
Try this formula in Column C. Assuming all of your data follows the formats
you provided, this should work:

=MID(B1,1,FIND(quot;quot;quot;quot;,B1,1))amp;MID(A1,1,FIND(quot;
quot;,A1,1)-1)amp;MID(B1,FIND(quot;quot;quot;quot;,B1,1) 1,1024)

HTH,
Elkarquot;Hayden Foxquot; wrote:

gt;
gt; Sorry to have posted this in 2 places but after my first post I realized
gt; that this board is the better one to post on as it states on the main
gt; page.
gt;
gt; Here is my problem.
gt;
gt; In COLUMN A, there is a list of cells containing numeric amp; text
gt; information. For example:
gt;
gt; Column A/Row 1 = 123456 Keyboards, Black
gt; Column A/Row 2 = 1234 Mice, Black
gt; Column A/Row 3 = 12345 Monitors, Gray
gt;
gt; In COLUMN B, there is a repeated list of text all the way down the
gt; column. For example:
gt;
gt; Column B/Row 1 = Textquot;quot;Text
gt; Column B/Row 2 = Textquot;quot;Text
gt; Column B/Row 3 = Textquot;quot;Text
gt;
gt; My goal here is to take the numeric portion from each cell in Column A
gt; and place that numeric portion in between the Quotation Marks (quot;quot;) in
gt; the corresponding cell in Column B.
gt;
gt; I tried to use the Help feature but after one hour of trying that still
gt; have no luck. Please help me if you can. I will pay you back someday
gt; somehow if you do.
gt;
gt;
gt; --
gt; Hayden Fox
gt; ------------------------------------------------------------------------
gt; Hayden Fox's Profile: www.excelforum.com/member.php...oamp;userid=30807
gt; View this thread: www.excelforum.com/showthread...hreadid=504680
gt;
gt;

Depending on how you view these groups, the formula may be affected by line
wrap. I use OE and this is the case.

In the 2nd FIND function there is a space between the quotes:

.......LEFT(A1,FIND(quot; quot;,A1)-1).......

Biff

quot;Biffquot; gt; wrote in message
...
gt; Hi!
gt;
gt; Here's a formula method that requires an additional column.
gt;
gt; In C1 enter this formula:
gt;
gt; =LEFT(B1,FIND(quot;quot;quot;quot;,B1)-1)amp;quot;quot;quot;quot;amp;LEFT(A1,FIND(quot;
gt; quot;,A1)-1)amp;quot;quot;quot;quot;amp;MID(B1,FIND(quot;quot;quot;quot;quot;quot;,B1) 2,255)
gt;
gt; Copy down as needed.
gt;
gt; Biff
gt;
gt; quot;Hayden Foxquot; gt;
gt; wrote in message
gt; ...
gt;gt;
gt;gt; Sorry to have posted this in 2 places but after my first post I realized
gt;gt; that this board is the better one to post on as it states on the main
gt;gt; page.
gt;gt;
gt;gt; Here is my problem.
gt;gt;
gt;gt; In COLUMN A, there is a list of cells containing numeric amp; text
gt;gt; information. For example:
gt;gt;
gt;gt; Column A/Row 1 = 123456 Keyboards, Black
gt;gt; Column A/Row 2 = 1234 Mice, Black
gt;gt; Column A/Row 3 = 12345 Monitors, Gray
gt;gt;
gt;gt; In COLUMN B, there is a repeated list of text all the way down the
gt;gt; column. For example:
gt;gt;
gt;gt; Column B/Row 1 = Textquot;quot;Text
gt;gt; Column B/Row 2 = Textquot;quot;Text
gt;gt; Column B/Row 3 = Textquot;quot;Text
gt;gt;
gt;gt; My goal here is to take the numeric portion from each cell in Column A
gt;gt; and place that numeric portion in between the Quotation Marks (quot;quot;) in
gt;gt; the corresponding cell in Column B.
gt;gt;
gt;gt; I tried to use the Help feature but after one hour of trying that still
gt;gt; have no luck. Please help me if you can. I will pay you back someday
gt;gt; somehow if you do.
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Hayden Fox
gt;gt; ------------------------------------------------------------------------
gt;gt; Hayden Fox's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=30807
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=504680
gt;gt;
gt;
gt;
This formula would go in column C (and if you wanted, you could copy
pastespecial values to column B.) This assumes that the cells in A always
start with the number and a space:

=LEFT(B1,FIND(quot;quot;quot;quot;,B1)-1)amp; quot;quot;quot;quot; amp; LEFT(A1, FIND(quot; quot;,A1)-1) amp; quot;quot;quot;quot; amp;
RIGHT(B1,LEN(B1)-(FIND(quot;quot;quot;quot;,B1) 1))

If the text in column B was as constant as your example implies, you could
enter the following formula in Column B and copy down:

=quot;Textquot;amp; quot;quot;quot;quot; amp; LEFT(A1, FIND(quot; quot;,A1)-1) amp; quot;quot;quot;quot; amp; quot;Textquot;
--
Kevin Vaughnquot;Hayden Foxquot; wrote:

gt;
gt; Sorry to have posted this in 2 places but after my first post I realized
gt; that this board is the better one to post on as it states on the main
gt; page.
gt;
gt; Here is my problem.
gt;
gt; In COLUMN A, there is a list of cells containing numeric amp; text
gt; information. For example:
gt;
gt; Column A/Row 1 = 123456 Keyboards, Black
gt; Column A/Row 2 = 1234 Mice, Black
gt; Column A/Row 3 = 12345 Monitors, Gray
gt;
gt; In COLUMN B, there is a repeated list of text all the way down the
gt; column. For example:
gt;
gt; Column B/Row 1 = Textquot;quot;Text
gt; Column B/Row 2 = Textquot;quot;Text
gt; Column B/Row 3 = Textquot;quot;Text
gt;
gt; My goal here is to take the numeric portion from each cell in Column A
gt; and place that numeric portion in between the Quotation Marks (quot;quot;) in
gt; the corresponding cell in Column B.
gt;
gt; I tried to use the Help feature but after one hour of trying that still
gt; have no luck. Please help me if you can. I will pay you back someday
gt; somehow if you do.
gt;
gt;
gt; --
gt; Hayden Fox
gt; ------------------------------------------------------------------------
gt; Hayden Fox's Profile: www.excelforum.com/member.php...oamp;userid=30807
gt; View this thread: www.excelforum.com/showthread...hreadid=504680
gt;
gt;