Left() and Right() Formula in one cell

**hack4u** · 05-12-2016, 09:40 AM

I'm stuck on the correct syntax and keep getting an error. I have a text string that I want to pull a specific measurement out of.

Example of data:

POR 12X24 AAA BBB
QWE 12x24 AAAAA BBBBBBBBBB
DEF 4X24 AAAF GGGGG
ABC 6X6 GG KKKK

I am able to do this in two separate cells but want to have it combined into one.

My Left Formula

Please Login or Register  to view this content.

My Right Formula

Please Login or Register  to view this content.

If there is a better approach please let me know.

**zbor** · 05-12-2016, 09:45 AM

Here:

Formula:

Please Login or Register  to view this content.

**zbor** · 05-12-2016, 09:46 AM

Another approach:

Formula:

Please Login or Register  to view this content.

**Tony Valko** · 05-12-2016, 09:49 AM

Maybe this...

Data Range

	A	B
1	POR 12X24 AAA BBB	12X24
2	QWE 12x24 AAAAA BBBBBBBBBB	12x24
3	DEF 4X24 AAAF GGGGG	4X24
4	ABC 6X6 GG KKKK	6X6

This formula entered in B1 and copied down:

=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",100)),100,100))

**hack4u** · 05-12-2016, 09:50 AM

Much appreciated. Never used the Trim before but will do some research to see how I can incorporate it into other projects.

**zbor** · 05-12-2016, 09:51 AM

TRIM is here just to remove all spaces from text (except for single spaces between words).

Left() and Right() Formula in one cell

LinkBack

Thread Tools

Rate This Thread

Display

Left() and Right() Formula in one cell

Re: Left() and Right() Formula in one cell

Re: Left() and Right() Formula in one cell

Re: Left() and Right() Formula in one cell

Re: Left() and Right() Formula in one cell

Re: Left() and Right() Formula in one cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] formula to reference cell on the left and add +1

Is there a formula that will extract the numbers to the left of the cell

Find cell with value from a column and insert formula in the cell to its left

[SOLVED] Formula to add a value to a cell, based on cell to the left's color

[SOLVED] Need to paste formula into a cell if cell to the left contains text...possible?

Formula for cell=exact(left...&2)

LEFT &RIGHT formula on the same cell

Bookmarks

Bookmarks

Posting Permissions