Hi there,
I hope someone can help me - I am trying to copy all the information in a cell before the last ",". I have a number of cells which contain info such as:
abc,def,ghi
ab,cdef,ghij
abcde,fgh
There is no set number of commas in all the cells and the lengths are all different. I want to be able to copy everything before the last comma.
Hope you can help!
Thanks.
K
I hope someone can help me - I am trying to copy all the information in a cell before the last ",". I have a number of cells which contain info such as:
abc,def,ghi
ab,cdef,ghij
abcde,fgh
There is no set number of commas in all the cells and the lengths are all different. I want to be able to copy everything before the last comma.
Hope you can help!
Thanks.
K