In the recent couple of articles, we've looked at different ways to remove characters from strings in Excel. Today, we'll investigate one more use case - how to delete everything before or after a specific character. Continue reading
Comments on: How to delete text before or after a certain character in Excel
by Svetlana Cheusheva, updated on
Table of contents
Comments page 2. Total comments: 51
Hello Sir,
I required VB function code for only removal XXXX.XXXMTQ XXX.XXXFTQ.
Example - as per showing
ASLS2O11252 1 BULK 20150.000KGS 25.000CBM
SN# 15577 44423.146MTQ 882.867FTQ
Need output - without removal SN Number and MTQ/FTQ number will be random number.
ASLS2O11252 1 BULK 20950.000KGS 25.000CBM
SN# 15577
Hello!
Unfortunately, we cannot write VBA code for you. But you can use the REGEX function to extract part of a string from text.
Hello team,
Can you help me to change PROD-001 to Product 1, I have been using multiple separate formula so it's kind of ugly.
I would be appreciated a lot. Thank you
Thanks a lot Sir,
I applied this formula it is working :-=LEFT(A1,MIN(IFERROR(FIND({1;2;3;4;5;6;7;8;9;0},A1,1),99999))-1)&" "&MID(A1,MIN(IFERROR(FIND({1;2;3;4;5;6;7;8;9;0},A1,1),99999)),50)
but only one string no changed i.e.65Hanjarwal
It is still 65Hanjarwal
can you help me I need like this result : 65 Hanjarwal
Hello dear Team,
I need your help, that I want make spaces between the text and number below
strings i tried myself but not get success.
text string
65Hanjarwal
C2160feetRoad
C19JaffriaColony
G14sunderIndustrialstate
CANAL BANK2
C18AshyanaHScty
222-LT-LTS-M15FZR
C41OPP240B
C2 84981C12
C13OPP3402C2
Thanks a lot
Hi!
To insert a space before the first digit you can use this formula:
=LEFT(A1,MIN(IFERROR(FIND({1;2;3;4;5;6;7;8;9;0},A1,1),99999))-1)&" "&MID(A1,MIN(IFERROR(FIND({1;2;3;4;5;6;7;8;9;0},A1,1),99999)),50)
This saved me so much time and energy. Super easy, way more efficient than manually updating 10690 columns of data. Thank you!