Get section of text from cell
Hey,
A long row of cells contains a item number and a item name, something like
this:
123456, item name
I only need the item number as a result. Is there a way to extract only the
text in front of a seperation mark (in this case the , )?
Note, the item number can contain numbers and/or letters and a interspace.
Thanks!
|