Name value position in a string of data
 

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

Name value position in a string of data
 

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

Name value position in a string of data
 

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

Name value position in a string of data
 

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