# Removing Numbers from a cell

#### nsaracco1

##### New Member
Hello, In cell E2 I have SESAME NJ 219211550. I am trying to leave the SESAME NJ in cell F2. Any suggestions?
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
 SESAME NJ 219211550

<tbody>
</tbody>
</body>

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

#### sandy666

##### Well-known Member
if this is representative example you can try PowerQuery(Get&Transform)

Code:
``````[SIZE=1]let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Extracted Text Before Delimiter" = Table.TransformColumns(Source, {{"raw", each Text.BeforeDelimiter(_, " ", {0, RelativePosition.FromEnd}), type text}})
in
#"Extracted Text Before Delimiter"[/SIZE]``````

 raw raw SESAME NJ 219211550 SESAME NJ

#### James006

##### Well-known Member
Hello,

You can use an Array Formula

Code:
``[FONT=inherit]=[/FONT][URL="https://exceljet.net/excel-functions/excel-textjoin-function"][FONT=inherit]TEXTJOIN[/FONT][/URL][FONT=inherit]([/FONT][FONT=inherit]""[/FONT][FONT=inherit],[/FONT][FONT=inherit]TRUE[/FONT][FONT=inherit],[/FONT][URL="https://exceljet.net/excel-functions/excel-if-function"][FONT=inherit]IF[/FONT][/URL][FONT=inherit]([/FONT][URL="https://exceljet.net/excel-functions/excel-iserr-function"][FONT=inherit]ISERR[/FONT][/URL][FONT=inherit]([/FONT][COLOR=#0062A0][FONT=inherit][URL="https://exceljet.net/excel-functions/excel-mid-function"]MID[/URL](E2[/FONT][/COLOR][FONT=inherit],[/FONT][URL="https://exceljet.net/excel-functions/excel-row-function"][FONT=inherit]ROW[/FONT][/URL][FONT=inherit]([/FONT][URL="https://exceljet.net/excel-functions/excel-indirect-function"][FONT=inherit]INDIRECT[/FONT][/URL][FONT=inherit]([/FONT][FONT=inherit]"1:100"[/FONT][FONT=inherit])),[/FONT][FONT=inherit]1[/FONT][FONT=inherit])[/FONT][FONT=inherit]+[/FONT][FONT=inherit]0[/FONT][FONT=inherit]),[/FONT][COLOR=#0062A0][FONT=inherit][URL="https://exceljet.net/excel-functions/excel-mid-function"]MID[/URL](E2[/FONT][/COLOR][FONT=inherit],[/FONT][URL="https://exceljet.net/excel-functions/excel-row-function"][FONT=inherit]ROW[/FONT][/URL][FONT=inherit]([/FONT][URL="https://exceljet.net/excel-functions/excel-indirect-function"][FONT=inherit]INDIRECT[/FONT][/URL][FONT=inherit]([/FONT][FONT=inherit]"1:100"[/FONT][FONT=inherit])),[/FONT][FONT=inherit]1[/FONT][FONT=inherit]),[/FONT][FONT=inherit]""[/FONT][FONT=inherit]))[/FONT]``

Hope this will help

Or this

#### Rick Rothstein

##### MrExcel MVP
Or this
Your formula will work one and two name cities only... unfortunately, New Jersey has a few three-name cities in it (South Bound Brook, West New York, etc.).

#### jtakw

##### Well-known Member
Hi,

A couple of Non-array formula options, normally entered:

Replies
1
Views
68
Replies
5
Views
334
Replies
10
Views
634
Replies
3
Views
407
Replies
4
Views
343