The Idea Dude
Well-known Member
- Joined
- Aug 15, 2002
- Messages
- 591
- Office Version
- 2016
- Platform
- Windows
Hi all,
I have a HUGE amount of info in a cel. I am aiming to do a trim function to extract certain info. I know that from the start of the text in the cell (cell representing 1 cell that i need to do this for multiple cells) that the first instance of QLD is my reference point. From this reference point I desire to move 4 commas to the left.
How would i do this?
Cheers
I have a HUGE amount of info in a cel. I am aiming to do a trim function to extract certain info. I know that from the start of the text in the cell (cell representing 1 cell that i need to do this for multiple cells) that the first instance of QLD is my reference point. From this reference point I desire to move 4 commas to the left.
How would i do this?
Cheers