Need help with Macro for excel 1

[hungry4mo]

I have a column filled with information that goes down to 200 rows. I need to remove the letters FC from the beginning text in those rows and replace it with 605ACE

 

[AnotherHiggins]

Does the string "FC" appear elsewhere in your data? If not, you could turn on your macro recorder and go to Edit > Replace, then replace FC with 605ACE.

If "FC" does appear elsewhere, then use a 'helper column' with this formula:
="605ACE"&right(A1,len(A1)-2)
That will create a string consisting of "605ACE" and whatever is in the cell, minus the first two characters.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[tinmar]

Excel Macro,

I have a sheet which asks for a name and a date, I then need the macro to go into a second sheet and grab that data which consists of 3 columns, name, data and some values which coincides with the name and date selected by the user

thank you

 

[AnotherHiggins]

tinmar,

Please create a new thread for this question.



[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.