Name value position in a string of data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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
 
It can happen iy your Windows list separator character occurs in the text to
be saved!

Regards,
Stefi

„diacci1st†ezt írta:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting a HEX string 2
Excel How to find the most common pairs and triplets numbers? 5
VLOOKUP 1
Len and InStr problem manipulating strings 3
Help with Replace() 11
Error 1004 when setting a Series Collection.Values as Array via VB 6
Excel Help to copy information from one row at a time to another sheet 1
Reallocate array cells value from positive to negative 0

Back
Top