I have 5 spreadsheets with 1,000 rows of data in each spreadsheet.
I need to format text in column A (AuthorId) that will identify it as a Twitter handle.
I need to have the following text added (twitter.com/) in front of existing text in cell A2 (milfordnissan).
The final result should look like this: twitter.com/milfordnissan
This step needs to be repeated for ALL cells in column A.
**OR the other option is to remove text in column C (AuthorUrl)
If we could remove the "http://
" from the beginning of the text in column C then I could still get my desired result which is: twitter.com/milfordnissan.
This step would need to be repeated for all cells in column C (AuthorUrl).
I am attaching the file. I have 4 other files that also need this macro to be applied.
I would appreciate step by step instructions or if someone could record the macro within my document, that would work too.