ExcelBanter - Descreption Seperation

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Descreption Seperation (https://www.excelbanter.com/excel-programming/375015-descreption-seperation.html)

Descreption Seperation

I need to seperate the words and demensions from A1 to A2(all
centence) and A3(Dimensions). Can somebody help me. I do have 3000
items in my list.
Thanks
Oleo Ball,Multi,Large dia27"
Pod Sculptural Vase,Amber,Large 32x9x41"h
Pod Sculptural Vase,Amber,Medium 22x5x29"h
Pod Sculptural Vase,Amber,Small
Red Fence Tree,Black,Lg. 17x2.5x17"h
Red Fence Tree,Black Md. 14x2.5x18"h

Dave Peterson

Descreption Seperation

You have an active thread in .excel.

Please don't multipost.

wrote:

I need to seperate the words and demensions from A1 to A2(all
centence) and A3(Dimensions). Can somebody help me. I do have 3000
items in my list.
Thanks
Oleo Ball,Multi,Large dia27"
Pod Sculptural Vase,Amber,Large 32x9x41"h
Pod Sculptural Vase,Amber,Medium 22x5x29"h
Pod Sculptural Vase,Amber,Small
Red Fence Tree,Black,Lg. 17x2.5x17"h
Red Fence Tree,Black Md. 14x2.5x18"h

--

Dave Peterson

All times are GMT +1. The time now is 08:58 AM.