Hi,
I want to find out entries where I want to check the entries where there is space between digit/s followed by chracters e.g
12 Ajay Sharma
I want to find out entries where
12Ajay Sharma is there out of 50 records. How to find it out?
Hi,
I want to find out entries where I want to check the entries where there is space between digit/s followed by chracters e.g
12 Ajay Sharma
I want to find out entries where
12Ajay Sharma is there out of 50 records. How to find it out?
I recommend uploading a small representative sample of your data along with the desired results (which you can enter manually) based on that data.
To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"
The entries are like these :
8 Sonali Thakur
9Rupesh Shah
10 Rahul Soni
11 Mohan Mishra
12 Ajay Sharma
13Rekha Gupta
14 Suresh Singh
15Rohan Thomas
Out of these entries, i would like to find out entries where Digits are alphabet are not seperated by space (i.e I want to find out entries like 9, 13, 15). The entries are not in sequence. How to do this using find facility
You didn't follow the instructions from post #2.
I was looking for the sample to be in an Excel workbook and for you to include the desired results in that workbook.
It is not clear to me what you would like to do once you find that 9, 13, and 15.
i hv attached the file. I want to identify entries like the entries on the row no : 2,6,8,11,13 using find and replace facility
No file attached.
sorry, PFA.
Okay so the sample is in now in Excel. The only thing that we still need to see is the desired results.
In your Excel workbook, clearly show what it is that you would like to happen then re-upload it.
Maybe have a before sheet and and after sheet.
Here's one way to identify them:
B1 =ISERROR(LEFT(A1,FIND(" ",A1))+0)
Drag the formula down column B.
No idea what you want with that row number or how to display.
I guess,
C1 drag down
=IF(ISERROR(--MID(A1,FIND(" ",A1)-1,1)),ROW(),"")
B1 for insert space
=TRIM(REPLACE(A1,MATCH(1,INDEX(-LEFT(A1,{1,2,3}),))+1,0," "))
Thank..It helps.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks