Separate text from numbers in a string?

L

LoriD

Board Regular
Joined
Apr 1, 2002
Messages
148
Is there a way to separate text from numbers, (other than text to columns)
My data is all different lengths, nothing consistent,plus I want to put the separated data in another column.
I'm hoping there is a formula???
Thanks in advance for your help.
 
Sort by date Sort by votes
This is all I could come up with, there's probably a more efficient way.

For the text string, say in B1:

=LEFT(A1,LOOKUP(2,1/NOT(ISNUMBER(FIND(MID(A1,ROW(INDIRECT("1:"&LEN(A14))),1),"0123456789-. "))),ROW(INDIRECT("1:"&LEN(A1)))))

(This just looks for the last character in the cell that is not a number, decimal point or hyphen, and returns the string up until that character).

For the first number after the text string:

=LOOKUP(9.99999999999999E+307,--LEFT(SUBSTITUTE(SUBSTITUTE(A1,B1,""),"- ","0 "),ROW(INDIRECT("1:"&LEN(A1)-LEN(B1)))))

(Note that this refers to the text returned in the first formula. It also converts a hyphen on it's own to a zero.)

Hope this is what you're after.

Cheers
A
 
Last edited:
Upvote 0

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Locked out of editing previous post, there was a rogue "4" in the first formula, correct one is:

=LEFT(A1,LOOKUP(2,1/NOT(ISNUMBER(FIND(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),"0123456789-. "))),ROW(INDIRECT("1:"&LEN(A1)))))
 
Upvote 0
Li

This may fail if the format of the numbers you are trying to extract is not consistently 1 decimal place. It also relies on the required number being the first number with a space before it (to exclude the '(5)' in your 5th example). Anyway, give this a try. Both formulas copied down.

Excel Workbook
ABC
1OriginalTextNumber
2Accounts Receivable 4,267.2Accounts Receivable4267.2
3Construction in Progress / Adjustments 1,461.4Construction in Progress / Adjustments1461.4
4Property, Plant, & Equipment 20,372.3Property, Plant, & Equipment20372.3
5Total Property, Plant, & Equipment - 11,839.2 377.2 9,617.3Total Property, Plant, & Equipment -11839.2
6Goodwill (5) 53,390.7 15,138.6 - 38,252.1Goodwill (5)53390.7
7Sub-Leases In-Place 7.3 - - 7.3Sub-Leases In-Place7.3
8
Extract Text and Number
 
Upvote 0
Peter_SSs said:
Li

This may fail if the format of the numbers you are trying to extract is not consistently 1 decimal place. It also relies on the required number being the first number with a space before it (to exclude the '(5)' in your 5th example). Anyway, give this a try. Both formulas copied down.

Excel Workbook
ABC
1OriginalTextNumber
2Accounts Receivable 4,267.2Accounts Receivable4267.2
3Construction in Progress / Adjustments 1,461.4Construction in Progress / Adjustments1461.4
4Property, Plant, & Equipment 20,372.3Property, Plant, & Equipment20372.3
5Total Property, Plant, & Equipment - 11,839.2 377.2 9,617.3Total Property, Plant, & Equipment -11839.2
6Goodwill (5) 53,390.7 15,138.6 - 38,252.1Goodwill (5)53390.7
7Sub-Leases In-Place 7.3 - - 7.3Sub-Leases In-Place7.3
8
Extract Text and Number
Click to expand...
Hi Peter,
Thank you so much for the formula. Like what you said, it does not work if the first number is missing with "-". I guess I can always replace the "-" with "0.0" and then replace it back when it is done.

I am a novice for excel. I am wondering if there is a way I can put this process into a VBA code since I have more than 50 files with exact the same accounting inputs (many obserables) that I need to separate the accounting variables from the numbers. Any hints will be really helpful!

Thanks ahead!
Li
 
Upvote 0
UDF
1) hit Alt + F11 to open vbe
2) go to [Insert] - [Module] then paste the code onto the right pane
3) hit Alt + F11 again to get back to Excel
4) select horizontal consecutive 2 cells like B1:C1
5) enter =zhang(A1) then confirm with Ctrl + Shift + Enter (array formula entry)
Code: 
Function zhang(txt As String) As Variant
Dim x As Double, y As String, m As Object
With CreateObject("VBcript.RegExp")
    .Pattern = "-?\s?(\d+,)?\d+(\.\d+)?"
    If .test(txt) Then
        Set m = .execute(txt)(0)
        zhang = Array(Left$(txt, m.firstindex), Trim(Replace(m.Value,"-","")))
    End If
End With
End Function
 
Upvote 0
jindon said:
UDF
1) hit Alt + F11 to open vbe
2) go to [Insert] - [Module] then paste the code onto the right pane
3) hit Alt + F11 again to get back to Excel
4) select horizontal consecutive 2 cells like B1:C1
5) enter =zhang(A1) then confirm with Ctrl + Shift + Enter (array formula entry)
Code: 
Function zhang(txt As String) As Variant
Dim x As Double, y As String, m As Object
With CreateObject("VBcript.RegExp")
    .Pattern = "-?\s?(\d+,)?\d+(\.\d+)?"
    If .test(txt) Then
        Set m = .execute(txt)(0)
        zhang = Array(Left$(txt, m.firstindex), Trim(Replace(m.Value,"-","")))
    End If
End With
End Function
Click to expand...
Hi Jingdon,
Thank you so much for the code. For some reason I got the results below on sheet1 after I copied VBA code: (Coulum A: data; Column B and Column C:results). Please let me know if I understand you incorrectly. Thanks ahead!

<TABLE style="WIDTH: 387pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=516 border=0><COLGROUP><COL style="WIDTH: 291pt; mso-width-source: userset; mso-width-alt: 14189" width=388><COL style="WIDTH: 48pt" span=2 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 291pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=388 height=20>Accounts Receivable 4,267.2 </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=middle width=64>#VALUE!</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=middle width=64>#VALUE!</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Construction in Progress / Adjustments 1,461.4 </TD><TD class=xl66 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Property, Plant, & Equipment 20,372.3 </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Total Property, Plant, & Equipment 0.0 11,839.2 377.2 9,617.3</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Goodwill (5) 53,390.7 15,138.6 - 38,252.1</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Sub-Leases In-Place 7.3 - - 7.3</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR></TBODY></TABLE>
 
Upvote 0
l2zhang said:
Hi Jingdon,
Thank you so much for the code. For some reason I got the results below on sheet1 after I copied VBA code: (Coulum A: data; Column B and Column C:results). Please let me know if I understand you incorrectly. Thanks ahead!

<TABLE style="WIDTH: 387pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=516 border=0><COLGROUP><COL style="WIDTH: 291pt; mso-width-source: userset; mso-width-alt: 14189" width=388><COL style="WIDTH: 48pt" span=2 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 291pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=388 height=20>Accounts Receivable 4,267.2 </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=middle width=64>#VALUE!</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=middle width=64>#VALUE!</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Construction in Progress / Adjustments 1,461.4 </TD><TD class=xl66 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Property, Plant, & Equipment 20,372.3 </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Total Property, Plant, & Equipment 0.0 11,839.2 377.2 9,617.3</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Goodwill (5) 53,390.7 15,138.6 - 38,252.1</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Sub-Leases In-Place 7.3 - - 7.3</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR></TBODY></TABLE>
Click to expand...
Yes, I did and it showed {=zhang(A1)} after I have done that. I should enter the data in column A in the same sheet with the function zhang(A1), right?
 
Upvote 0
How about?
Code: 
Function zhang(txt As String) As Variant
Dim x As Double, y As String, m As Object
With CreateObject("VBcript.RegExp")
    .Pattern = "(\d+,)*\d+(\.\d+)?"
    If .test(txt) Then
        Set m = .execute(txt)
        zhang = Array(Left$(txt, m.item(0).FirstIndex), m.item(0).Value)
    End If
End With
End Function
 
Upvote 0
jindon said:
How about?
Code: 
Function zhang(txt As String) As Variant
Dim x As Double, y As String, m As Object
With CreateObject("VBcript.RegExp")
    .Pattern = "(\d+,)*\d+(\.\d+)?"
    If .test(txt) Then
        Set m = .execute(txt)
        zhang = Array(Left$(txt, m.item(0).FirstIndex), m.item(0).Value)
    End If
End With
End Function
Click to expand...
<TABLE style="WIDTH: 637pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=849 border=0><COLGROUP><COL style="WIDTH: 291pt; mso-width-source: userset; mso-width-alt: 14189" width=388><COL style="WIDTH: 298pt; mso-width-source: userset; mso-width-alt: 14518" width=397><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 291pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=388 height=20>Accounts Receivable 4,267.2 </TD><TD class=xl66 id=td_post_1762703 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 298pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=middle width=397>#NAME?</TD><TD class=xl66 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" align=middle width=64>#NAME?</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Construction in Progress / Adjustments 1,461.4 </TD><TD class=xl66 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Property, Plant, & Equipment 20,372.3 </TD><TD class=xl66 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Total Property, Plant, & Equipment 0.0 11,839.2 377.2 9,617.3</TD><TD class=xl66 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Goodwill (5) 53,390.7 15,138.6 - 38,252.1</TD><TD class=xl66 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Sub-Leases In-Place 7.3 - - 7.3</TD><TD class=xl66 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD class=xl66 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR></TBODY></TABLE>
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
How to remove variably placed text within a string of text by looking at the columns to the right
Replies
1
Views
109
Alex Blakenburg
A
A
  • Question Question
Parsing text with different number of dashes
Replies
6
Views
303
alansidman
A
H
  • Question Question
List out duplicate items in a list with different costs/values
Replies
6
Views
149
H3MSY
H
F
  • Solved
Colour all blank cells in a row if one cell in row has text.
Replies
3
Views
427
Joe4
Joe4
T
  • Question Question
Split content on new sheet and extract info in parentheses
2
Replies
10
Views
266
DanteAmor
DanteAmor

Forum statistics

Threads
1,223,911
Messages
6,175,337
Members
452,636
Latest member
laura12345

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top