I have a long list of numbers and letters and names which which are all in a single cell. The text in each cell is currently separated by spaces and I need the first two spaces increased by two spaces each.
E g. 10.001 BF123 Tischeria ekebladella.
E g. 10.001 BF123 Tischeria ekebladella.
Another added problem with this issue is that the current spaces in each cell aren't necessarily in the same position in every cell, therefore you can't use a formula which counts the number of letters and/or numbers before each space.
E g. 10.001 BF123 Tischeria ekebladella.
E.g. 73.3031 BF2210 The Maori Graphania averilla
Hopefully some one can help me with this issue, thanks.
Bookmarks