ExcelBanter - Help finding the last space in a cell

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Help finding the last space in a cell (https://www.excelbanter.com/excel-worksheet-functions/218221-help-finding-last-space-cell.html)

[email protected]

Help finding the last space in a cell

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
Company B
CompC

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.

Glenn

Help finding the last space in a cell

wrote:
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
Company B
CompC

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.

=TRIM(SUBSTITUTE(A1,TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99)),""))

Shane Devenshire[_2_]

Help finding the last space in a cell

Hi,

You can use the following array formula

=LEFT(A1,MAX(IF(MID(A1,ROW(A1:A99),1)=" ",ROW(A1:A99),"")))

This assumes that the entry is in B1. To enter an array press
Shift+Ctrl+Enter
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire

" wrote:

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
Company B
CompC

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.

All times are GMT +1. The time now is 01:35 PM.