Find "__"x"__" regardless of digits. The anti-concatenate....

**esmithqg** · 02-01-2013, 07:13 PM

Hello,
I have a long list of values that all have an "x" between two numbers. I need to split out the numbers into their own columns.
Not all numbers are whole numbers. The cell contents could be "3x5" or "11.6875x8.125" or other decimal points.
Is there a find formula I can use?
Thanks!
E

**TMS** · 02-01-2013, 07:23 PM

It would be easiest to use Text to Columns with "x" as the delimiter.

Regards, TMS

**scott.s.fower** · 02-01-2013, 07:23 PM

you could do text to columns with x as the deliminator

**scott.s.fower** · 02-01-2013, 07:24 PM

damn you TMShucks, beat me by a few seconds

**TMS** · 02-01-2013, 07:45 PM

You need to type a little more quickly

Anyway, great minds ...

Regards, TMS

**esmithqg** · 02-02-2013, 10:15 PM

Brilliant!
Thank you both very much.
E

**TMS** · 02-02-2013, 10:42 PM

You're welcome.

Find ""x"" regardless of digits. The anti-concatenate....

LinkBack

Thread Tools

Rate This Thread

Display