Related Posts
Additional Posts in Excel Genius
What are the most typical models you all build
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
What are the most typical models you all build
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Download the Fishbowl app to unlock all discussions on Fishbowl.
Copy and paste embed code on your site
Send download link to your phone
OR
Scan your QR code to download
Fishbowl app on your mobile
Without a character limit *
Try text to column feature to break up the column if there is a limit to the number of characters the data can pull from.
Select column, hit alt, a, e
Then fixed length And then arbitrarily break the column into two
You can do the formula left or right it pulls a certain number of digits from the left or the right as indicated
I would try it but if it doesn’t work try text to columns