Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by johnbarr44

  1. johnbarr44

    Excel, how to enter space between initials in name column

    Many Thanks strongm. That did the trick and saved me a heap of work.
  2. johnbarr44

    Excel, how to enter space between initials in name column

    I have been asked to correct a spreadsheet listing thousands of surnames and initials in two columns, with further columns containing data for each person. The 'initials' column contains either one, two or three upper case initials. The initials have no spaces between them, but these are...
  3. johnbarr44

    Correcting errors from 'Change Case' format

    Thanks for your reply, Paul, and for sharing your very sophisticated code. Yes, I agree there are some drawbacks with the code I've used, but I modified it slightly e.g. to eliminate the 'Van', 'Von', 'De', options. As my Excel column contained only surnames it will suffice, but I can...
  4. johnbarr44

    Correcting errors from 'Change Case' format

    In case anyone else is looking for this, I found exactly what I wanted here.... http://dmcritchie.mvps.org/excel/code/proper.txt John B
  5. johnbarr44

    Correcting errors from 'Change Case' format

    Hi Zack Thanks for your reply. Sorry but I've never used UDF before, and a search of the subject suggests it would take a while to learn (well, for me, anyway!). Any chance of showing the equivalent code for a macro? John B
  6. johnbarr44

    Correcting errors from 'Change Case' format

    I'm using Excel 2003, and have a surname column where all entries have been entered in uppercase. I wish to convert this format to 'Title Case', and have achieved it in most cases by copying to Word then using the 'Change Case' format function, then copying back into Excel. However, it results...
  7. johnbarr44

    Merging text in two adjacent cells

    Thanks Duane, that did it! [smile] John B
  8. johnbarr44

    Merging text in two adjacent cells

    Sorry, should have mentioned I'm using Excel 2003. John B
  9. johnbarr44

    Merging text in two adjacent cells

    I have two columns, Surname and Given Name. Given Name column contains a mixture of initials, (some with words) e.g. A, AB, AB and CD, and words e.g. Alan, John and Fred, Bros, Brothers. Wherever the Given Name is "Bros" or "Brothers" I would like to cut that word from the Given Name column...
  10. johnbarr44

    Remove punctuation from Excel text

    Ahh! So simple, but frustratingly hard to find for a beginner. (old fuddy duddy!) Thanks again, Skip. John B
  11. johnbarr44

    Remove punctuation from Excel text

    Thank you, Skip. That's certainly a lot tidier than my effort. Is there a way to include an instruction in the macro so that it runs only on a selection, i.e. so I can select any group of cells before running the macro, rather than have it work on the whole sheet. I have searched for an answer...
  12. johnbarr44

    Remove punctuation from Excel text

    Thanks for pointing me in the right direction, Skip. I finally figured it was necessary to run the "Replace" function four times in the same macro to eliminate all four punctuation items. John B
  13. johnbarr44

    Remove punctuation from Excel text

    Hi Skip, I think this is it ?? Sub Punctuation() ' ' Punctuation Macro ' Macro recorded 2/08/2012 by John B ' ' Keyboard Shortcut: Ctrl+p ' Cells.Replace What:="""", Replacement:="", LookAt:=xlPart, SearchOrder _ :=xlByRows, MatchCase:=False, SearchFormat:=False...
  14. johnbarr44

    Remove punctuation from Excel text

    I would like to remove punctuation from a selection of columns containing text (in Excel 2003). In particular, the following four characters , . ' " Is it possible to write a macro to achieve that? Thanks John B
  15. johnbarr44

    Eliminate spaces between Initials in First Names column

    Thank you Andy, That is much quicker and easier and does just what I wanted. Cheers John B
See more

Part and Inventory Search

Back
Top