Hi folks, when I copy an AIB Visa statement from IBB and paste into excel for upload it’s putting spaces at the start of every cell.which causes the upload to fail. Is there an easy work around this other than having to go into every cell individually and remove the space? Many thanks, Sonya

Vote Up
0
Vote Down

Hi folks, when I copy an AIB Visa statement from IBB and paste into excel for upload it’s putting spaces at the start of every cell.which causes the upload to fail. Is there an easy work around this other than having to go into every cell individually and remove the space? Many thanks, Sonya

1 answer

Vote Up
0
Vote Down
Peter Connor ⋅ Staff October 9, 2015
Public

Hi S, try doing a find and replace for a space.
I’ll try it here.

#answer-1912
  1. office urparts October 9, 2015
    I already tried that and it removes the spaces within the description text itself but not the first space.
  2. Peter Connor October 9, 2015
    Did you do a search on Google.
  3. Peter Connor October 9, 2015
    First thing that came up for me "Click in the first cell of a blank column on your spreadsheet. Type an equal sign to signal Excel that the cell will contain a formula. Type "TRIM(" – without quotation marks – and click on the location of the first cell in the column that contains data you want to clean up."
  4. office urparts October 9, 2015
    No you were my first port as I thought you would have come across this already with other people.
  5. Peter Connor October 9, 2015
    People have trouble with excel and copying from the web, but it's usually the formatting of the cell. Banks should be opening data in a year so this will be fixed.
    https://www.google.ie/search?sourceid=chrome-psyapi2&ion=1&espv=2&ie=UTF-8&q=how%20to%20remove%20spaces%20in%20excel&oq=how%20to%20remove%20spaces%20&aqs=chrome.0.0j69i57j0l4.6005j0j7
  6. office urparts October 9, 2015
    AHHHH I effing hate formulasl!!!!!
  7. Peter Connor October 9, 2015
    Sonya, they're numbers too.

Please login or Register to Submit Answer