1 2 3 4 5
Raw Data Trim Left Trim Right Copy & Paste Value TRIM
George George Washington 1
1. George Washington 1789 -1797Washington 1789 -1797 George Washington George Washington
2. John Adams 1797-1801John Adams 1797-1801 AdamsJohn John Adams John Adams
Thomas Thomas
3. Thomas Jefferson 1801-1809 Jefferson 1801-1809 Jefferson Thomas Jefferson Thomas Jefferson
4. James Madison 1809-1817 James
James Madison 1809-1817 Madison James Madison James Madison
5. James Monroe 1817-1825 James
James Monroe 1817-1825 Monroe James Monroe James Monroe
John Quincy Adams 1825-1829 Adams John Quincy Adams John Quincy Adams
6. John Quincy Adams 1825-1829 John Quincy
7. Andrew Jackson 1829-1837 Andrew
Andrew Jackson 1829-1837 Jackson Andrew Jackson Andrew Jackson
Martin
8. Martin Van Buren 1837-1841 Van Buren 1837-1841Martin Van Buren Martin Van Buren Martin Van Buren
William Henry Harrison 1841-Henry Harrison
9. William Henry Harrison 1841- 1841 William 1841 William Henry HarrisonWilliam Henry Harrison
10. John Tyler 1841-1845 John Tyler 1841-1845 John Tyler John Tyler John Tyler
James James
11. James Knox Polk 1845-1849 Knox Polk 1845-1849Knox Polk James Knox Polk James Knox Polk
Zachary Taylor 1849-1850
12. Zachary Taylor 1849-1850 Zachary Taylor Zachary Taylor Zachary Taylor
Millard Millard
13. Millard Fillmore 1850-1853 Fillmore 1850-1853 Fillmore Millard Fillmore Millard Fillmore
Franklin Pierce 1853-1857
14. Franklin Pierce 1853-1857 Franklin Pierce Franklin Pierce Franklin Pierce
James James
15. James Buchanan 1857-1861 Buchanan 1857-1861Buchanan James Buchanan James Buchanan
Abraham Lincoln 1861-1865 Lincoln
16. Abraham Lincoln 1861-1865 Abraham Abraham Lincoln Abraham Lincoln
Andrew Andrew
17. Andrew Johnson 1865-1869 Johnson 1865-1869 Johnson Andrew Johnson Andrew Johnson
Ulysses Simpson Grant 1869-1877
18. Ulysses Simpson Grant 1869-1877 Ulysses Simpson GrantUlysses Simpson Grant Ulysses Simpson Grant
Rutherford Birchard Hayes 1877-1881
19. Rutherford Birchard Hayes 1877-1881 Rutherford Birchard Hayes
Rutherford Birchard Hayes Rutherford Birchard Hayes
1881 James
20. James Abram Garfield James Abram Garfield 1881 Abram Gar James Abram Gar James Abram Gar
Chester Chester Alan Arthur Chester Alan Arthur Chester Alan Arthur
21. Chester Alan Arthur 1881-1885 Alan Arthur 1881-1885
Grover Grover
22. Grover Cleveland 1885-1889 Cleveland 1885-1889Cleveland Grover Cleveland Grover Cleveland
Benjamin Benjamin
23. Benjamin Harrison 1889-1893 Harrison 1889-1893 Harrison Benjamin Harrison Benjamin Harrison
Grover Grover
24. Grover Cleveland 1893-1897 Cleveland 1893-1897Cleveland Grover Cleveland Grover Cleveland
William William
25. William McKinley 1897-1901 McKinley 1897-1901 McKinley William McKinley William McKinley
Theodore Theodore
26. Theodore Roosevelt 1901-1909 Roosevelt 1901-1909Roosevelt Theodore Roosevelt Theodore Roosevelt
William Howard Taft 1909-1913
27. William Howard Taft 1909-1913 William Howard Taft William Howard Taft William Howard Taft
Woodrow Wilson 1913-1921 Wilson
28. Woodrow Wilson 1913-1921 Woodrow Woodrow Wilson Woodrow Wilson
Warren Gamaliel Harding 1921-1923 Harding
29. Warren Gamaliel Harding 1921-1923 Warren Gamaliel Warren Gamaliel Harding
Warren Gamaliel Harding
Calvin Calvin
30. Calvin Coolidge 1923-1929 Coolidge 1923-1929 Coolidge Calvin Coolidge Calvin Coolidge
Herbert Clark HooverHerbert Clark HooverHerbert Clark HooverHerbert Clark Hoover
31. Herbert Clark Hoover 1929-1933 1929-1933
Franklin Delano Franklin Delano
32. Franklin Delano Roosevelt 1933-1945 Roosevelt 1933-1945Roosevelt Franklin Delano Roosevelt
Franklin Delano Roosevelt
Harry Harry S.
33. Harry S. Truman 1945-1953 S. Truman 1945-1953 Truman Harry S. Truman Harry S. Truman
Dwight David Dwight David Eisenhower David Eisenhower David Eisenhower
34. Dwight David Eisenhower 1953-1961Eisenhower 1953-1961 Dwight Dwight
John Fitzgerald John Fitzgerald John John
35. John Fitzgerald Kennedy 1961-1963 Kennedy 1961-1963 Kennedy Fitzgerald Kennedy Fitzgerald Kennedy
Lyndon Baines Lyndon Baines
36. Lyndon Baines Johnson 1963-1969 Johnson 1963-1969 Johnson Lyndon Baines Johnson Lyndon Baines Johnson
1969-1974 Richard Milhous Nixon ichard Milhous Nixon ichard Milhous Nixon
37. Richard Milhous Nixon Richard Milhous Nixon 1969-1974 R R
Gerald Rudolph Ford Gerald Rudolph Ford Gerald Rudolph Ford Gerald Rudolph Ford
38. Gerald Rudolph Ford 1974-1977 1974-1977
James Earl 1977-1981
39. James Earl Carter Jr. 1977-1981 Carter Jr.James Earl Carter Jr.James Earl Carter Jr.James Earl Carter Jr.
1981-1989 Ronald Wilson
40. Ronald Wilson ReaganRonald Wilson Reagan 1981-1989 Reagan Ronald Wilson Reagan Ronald Wilson Reagan
George Herbert Walker Bush Herbert Walker Bush Herbert Walker Bush Herbert Walker Bush
41. George Herbert Walker Bush 1989-1993 George 1989-1993 George George
William Jefferson Clinton 1993-2001 Clinton
42. William Jefferson Clinton 1993-2001 William Jefferson William Jefferson Clinton
William Jefferson Clinton
George Walker Bush George Walker Bush George Walker Bush George Walker Bush
43. George Walker Bush 2001-2009 2001-2009
Barack Hussein Obama 2009 - present. Barack Hussein Obama
44. Barack Hussein Obama 2009 - present. Barack Hussein Obama 2009 Barack Hussein Obama
6 7 8
Last Name First Name Concatenate
Washington George Washington, George
Adams John Adams, John
Jefferson Thomas Jefferson, Thomas
Madison James Madison, James
Monroe James Monroe, James
Adams John Adams, John
Jackson Andrew Jackson, Andrew
Buren Martin Buren, Martin
Harrison William Harrison, William
Tyler John Tyler, John
Polk James Polk, James
Taylor Zachary Taylor, Zachary
Fillmore Millard Fillmore, Millard
Pierce Franklin Pierce, Franklin
Buchanan James Buchanan, James
Lincoln Abraham Lincoln, Abraham
Johnson Andrew Johnson, Andrew
Grant Ulysses Grant, Ulysses
Hayes Rutherford Hayes, Rutherford
Gar James Gar, James
Arthur Chester Arthur, Chester
Cleveland Grover Cleveland, Grover
Harrison Benjamin Harrison, Benjamin
Cleveland Grover Cleveland, Grover
McKinley William McKinley, William
Roosevelt Theodore Roosevelt, Theodore
Taft William Taft, William
Wilson Woodrow Wilson, Woodrow
Harding Warren Harding, Warren
Coolidge Calvin Coolidge, Calvin
Hoover Herbert Hoover, Herbert
Roosevelt Franklin Roosevelt, Franklin
Truman Harry Truman, Harry
Eisenhower Dwight Eisenhower, Dwight
Kennedy John Kennedy, John
Johnson Lyndon Johnson, Lyndon
Nixon Richard Nixon, Richard
Ford Gerald Ford, Gerald
Jr. James Jr., James
Reagan Ronald Reagan, Ronald
Bush George Bush, George
Clinton William Clinton, William
Bush George Bush, George
Obama Barack Obama, Barack