Separate s.no

[guptasweb]

how to separate the S.no from text in excel file???

[shreyash_shirbhate]

Can you please give the sample string here? @guptasweb

Or may be screenshot will work!

[guptasweb]

[shreyash_shirbhate]

So 1.1.1.1 are the serial numbers right? @guptasweb

[guptasweb]

yes…correct

[shreyash_shirbhate]

I guess you are extracting this data from word doc right? @guptasweb

[guptasweb]

hmmm…right

[shreyash_shirbhate]

So while dumping the data into excel you can remove those from word and then dump it @guptasweb

is this not possible?

[shreyash_shirbhate]

@guptasweb

Removing Line Numbering (Microsoft Word)

Try to do this with automation and then paste it into excel sheet.

[guptasweb]

and its output should be like this

[Nithinkrishna]

Hey @guptasweb

You need to remove the S.No alone which is fine or you want the format as you posted above ?

Thanks
#nK

[guptasweb]

i want the format which includes s.no and title

[Nithinkrishna]

Hey @guptasweb

Cool. Is it possible for you to share the file here please ?

Thanks
#nK

[guptasweb]

which file word,excel or xaml??

[Nithinkrishna]

Word file with expected output excel file.

[guptasweb]

AAM-5Ref-150-01-Equipment Sourcing.docx (109.1 KB)
0OutputSheet.xlsx (47.3 KB)

[Nithinkrishna]

Thanks @guptasweb

Will check

[Nithinkrishna]

Hey @guptasweb

Here you go…

nmnithinkrishna_WordToExcel_19Apr2022_2234.zip (182.3 KB)

Kindly check and if you face any challenges please let us know.

Thanks
#nK

[guptasweb]

hats of 2 u man…

[Nithinkrishna]

Cool buddy