Hi
I have a TXT file that I need to modify before I send it and replace some of
the data on it.
So I was thinking to import it in Excel than give a name to a position in
the string EG:
A = 61 to 71 and than replace the value in 61 to 71 with *******
How can I do the above or do you know any other ways?
I need to do this for multiple positions in the string of data.
Thank you for your help.

AD

If your text is in column A then enter this formula in B1
=LEFT(A1,60)&REPT("*",7)&MID(A1,72,LEN(A1))
Copy down as necessary,
Select column B, copy, PasteSpecial/Values into Column A,
Delete column B
Save the workbook as txt file!


Regards,
Stefi

€ždiacci1st€� ezt Ã*rta:

Hi
I have a TXT file that I need to modify before I send it and replace some of
the data on it.
So I was thinking to import it in Excel than give a name to a position in
the string EG:
A = 61 to 71 and than replace the value in 61 to 71 with *******
How can I do the above or do you know any other ways?
I need to do this for multiple positions in the string of data.
Thank you for your help.

AD

HI Stefi
Thank you for your help!!
When I open the file in TXT after the changes all the lines have " at the
start and at the end of each line..
Do you know how I could stop this from happening as I have over 30 files to
do monthly and wont be able to do it manually...

Thank you

"Stefi" wrote:

If your text is in column A then enter this formula in B1
=LEFT(A1,60)&REPT("*",7)&MID(A1,72,LEN(A1))
Copy down as necessary,
Select column B, copy, PasteSpecial/Values into Column A,
Delete column B
Save the workbook as txt file!


Regards,
Stefi

€ždiacci1st€� ezt Ã*rta:

Hi
I have a TXT file that I need to modify before I send it and replace some of
the data on it.
So I was thinking to import it in Excel than give a name to a position in
the string EG:
A = 61 to 71 and than replace the value in 61 to 71 with *******
How can I do the above or do you know any other ways?
I need to do this for multiple positions in the string of data.
Thank you for your help.

AD

It can happen iy your Windows list separator character occurs in the text to
be saved!

Regards,
Stefi

€ždiacci1st€� ezt Ã*rta:

HI Stefi
Thank you for your help!!
When I open the file in TXT after the changes all the lines have " at the
start and at the end of each line..
Do you know how I could stop this from happening as I have over 30 files to
do monthly and wont be able to do it manually...

Thank you

"Stefi" wrote:

If your text is in column A then enter this formula in B1
=LEFT(A1,60)&REPT("*",7)&MID(A1,72,LEN(A1))
Copy down as necessary,
Select column B, copy, PasteSpecial/Values into Column A,
Delete column B
Save the workbook as txt file!


Regards,
Stefi

€ždiacci1st€� ezt Ã*rta:

Hi
I have a TXT file that I need to modify before I send it and replace some of
the data on it.
So I was thinking to import it in Excel than give a name to a position in
the string EG:
A = 61 to 71 and than replace the value in 61 to 71 with *******
How can I do the above or do you know any other ways?
I need to do this for multiple positions in the string of data.
Thank you for your help.

AD