C
ciaran.hudson
I need to isolate all the characters in a cell prior to the last
space.
Can anyone tell me how to find the the posistion of the last space in
the cell?
This is an example of my data:
CompanyA (e-mail address removed)
Company B (e-mail address removed)
CompC (e-mail address removed)
The output I want from my formula is:
CompanyA
Company B
CompC
I'm trying use a LEFT formula knowing the position of the last space;
but other suggestions are welcome.
space.
Can anyone tell me how to find the the posistion of the last space in
the cell?
This is an example of my data:
CompanyA (e-mail address removed)
Company B (e-mail address removed)
CompC (e-mail address removed)
The output I want from my formula is:
CompanyA
Company B
CompC
I'm trying use a LEFT formula knowing the position of the last space;
but other suggestions are welcome.