PPRuNe Forums - View Single Post - EXCEL - find and repalce tabs in cells
View Single Post
Old 8th Sep 2018, 15:42
  #6 (permalink)  
friartuck
 
Join Date: Aug 2018
Location: Derby
Posts: 0
Likes: 0
Received 0 Likes on 0 Posts
Looks like it came from WORD - soooooooooo

1. Copy all the cells (or each cell at a time)

2. paste into a WORD document
3. in WORD open Replace and go to “More”
4. In “Find what” enter ^t
5. in “Replace with” enter two spaces or whatever
6. “Replace all”
7. Copy and repaste into the spreadsheet


Seems to work
friartuck is offline